PPi Learning Services courses

...Create and Maintain Local Catalog Structure Understanding the Search Engine Setting Up Remote Content iProcurement Shopping Setup For iProcurement Shopping...

...After completing this course delegates will be able to create and submit both standard and customised reports using data within the General Ledger module...

...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...

...Course content Overview of the Oracle Receivables Process AR as part of the Financials Suite Manage the Customer Database Run Customer Account Inquiries...

...or Cancel Invoices Carry Out Invoice Enquiries Match Invoices to Purchase Orders and Receipts Enter Recurring Invoices * Process Prepayments Process Holds...

...necessary to perform every day tasks. Course content Oracle Financials Overview General Ledger Overview Set of Books Chart of Accounts Structure Account...

...Features New Memory Management Features Database Replay to Capture, Process and Replay a Workload ASMImprovements The Data Recovery Advisor and Flashback...

...Course content Overview of Oracle Application Express SQLWorkshop Build an Application Create Reports and Forms Pages and Regions Items and Buttons...

...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...

...and UnNamed Exceptions Generating User Defined Exceptions Nested and Labelled Block Structures Scope of Variables PL/SQL Records PL/SQL Tables of Records...

...cover the basic features of the Oracle database such as Oracle architecture, database objects, transaction processing and security. By the end of...

...Regular Expression Notation Regular Expression Functions Enhanced Subquery Functions Multitable Insert Statements Merge Rows in a Table External Tables...

...Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience. Course content The Structure...

...Indexes Creating and Using Views StructuringSQLStatements for Performance Using theSQLOptimizers Examining the Execution Plan of aSQLStatement usingEXPLAINPLAN...

...Deterministic Functions Using Stored Functions inSQL Creating and Managing Packages Implementing Package Features and Constructs Wrapping Packages Cursor...

...of Subledger Data to the General Ledger Reporting Tools Folder Usage Flexfield Overview Key and Descriptive Flexfields Oracle Workflow Overview Customer...

...By the end of this course, delegates will be able to set up and use Oracle Cash Management. They will know how to import bank statements, reconcile...

...Assets with Multiple Assignments Mass Additions Create and Prepare Mass Addition Lines Post Mass Additions CIPAsset Additions Adjust and Maintain Assets...

...Components Plan a Workflow Process Diagram a Workflow Process Define Item Type Attributes and Lookup Types Define Messages and Notification Activities...