PPi Learning Services courses

...Creating Requisitions Managing Requisitions Setting Up Procurement Cards Understanding Requisition Setup Options iProcurement Receiving Setup Prerequisites...

...Course content Oracle Financials Reporting Tools Standard Report Categories Run Standard Reports with Submit Request Form Overview of the Financial Statement Generator (FSG)...

...By the end of the course, delegates will be able to; manage users and system security; set up and manage printers; create and implement menus...

...process transactions, manage collections, submit reports, close accounts receivables periods and transfer account details to the General Ledger. Course...

...Course content Overview of the Oracle Account Payables process Supplier Set Up * Supplier Management Enter, Review and Approve Supplier Invoices Adjust...

...Encumbrances and Budgets Create Manual and Statistical Journals Find and Amend a Journal Generate a Reversing Journal Approve Manual Journal Entries...

...Transaction Management using Flashback and LogMiner RMANNew Features Data Guard Improvements Performance Tuning New Features New Security Features...

...Processing Shared Components Display Dynamic Content Session State and Debugging Themes and Templates Administer Workspaces Implement Security Deploy...

...Course content Introduction to Oracle Forms Services The OC4J Component The Forms Servlet and Forms Listener Servlet The Main Configuration Files Default...

...merge and delete rows, grant and revoke access privileges and access the Data Dictionary Course content Overview of Oracle Database features UsingSQL*Plus...

...IFTHENELSIFELSEStatements CASEExpressions Basic Loops TheWHILEandFORLoops Nested and Labelled Loops Using Cursors Parameterised Cursors Handling Named...

...Recovery Advisor Proactive Health Checks Oracle Security Features Tool Sets for Administering and Configuring an Oracle Database Backup and Recovery Concepts...

...write multiple column subqueries, manage large data sets with subqueries and construct hierarchical queries. Delegates will also be able to use the ROLLUP...

...use SQL Developer to access an Oracle Database, create SQL statements to select data from an Oracle Database and yse SQL run time parameters...

...By the end of the course, the delegate will be able to tune applications for optimal performance, optimize SQL queries for faster access and tune...

...and Compile Time Warnings The DBMS_SQL Package Native DynamicSQL Oracle Supplied Packages The DBMS_METADATA Package Overview of DBMS_SCHEDULER...

...It is intended that this seminar will provide a forum for discussion on possible implementation issues and problems. Course content Overview of the Oracle...

...Lines Enter Bank Statements Manually Reconcile Journal Entries Create Transactions Bank Statement Interface Enter and Update Manual Bank Statements...

...They will be able to add an asset, adjust and revalue an asset, calculate depreciation on an asset, transfer an asset and retire an asset. Delegates...

...They will learn how to design a simple workflow and save it to the database. Course content 11i/2.6 E-Business Functional Workflow Overview Oracle Workflow...