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

...Run Transaction Inquiries Run Credit Control (Aged Debt) Inquiries Raise sales invoices or Invoice Batches Copy a Sales Invoice * Void a Sales Invoice...

...process invoices, credit notes and payments, submit reports, close accounts payable periods and transfer accounting details to the General Ledger. Course...

...a Journal Batch Create Recurring and Formula Journal Template Use Balancing Accounts Transfer Balances between Accounts Concurrent Processes Month...

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

...Delegates will also be able to use and manage shared components, manage database objects, deploy an application and authorize and authenticate users and administer workspaces...

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

...andSQLDeveloper Querying the Oracle Database Subqueries and in-line views Numeric functions Character functions Common date and timestamp functions Actual...

...Course content Program Blocks Variables and Constants Data Types * UsingSQLStatements within PL/SQL Programs GeneratingSQL*Plus andSQLDeveloper Output...

...Database Objects Oracle Architecture Real Application Clusters Technology Data Guard and Standby Databases Automatic Storage Management Flashback...

...Hierarchical Queries Enhanced Grouping Extensions and Functions TIMESTAMP,TIMEZONEandINTERVALDatatypes TIMESTAMPandINTERVALFunctions and Literals POSIXCompliant...

...use the command line features of SQL*Plus, use SQL Developer to access an Oracle Database, create SQL statements to select data from an Oracle Database...

...Examining the Efficiency ofSQLStatements usingSQLTrace and Autotrace Using Hints to Influence Execution Plan Identifying Unused Indexes PL/SQL Tuning Issues...

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

...reconcile them and post updated information to the Oracle General Ledger. Delegates will be able to create cash forecasts. Course content Overview of Oracle...

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