| First Week |
| Introduction |
| Definitions, Oracle as a Database |
| Database Objects |
| Data Types |
| Introduction to SQL |
| Basic SQL Commands |
| Tables ,Extracting data from Tables, Creating and Altering tables, Constraints |
| Built-In-Functions, Operators, View, Sequence, Synonym, Index |
| Introduction PL/SQL |
| Block Structure, Procedure, Function, Package, Trigger |
| Advanced Topics |
| Oracle Tools |
| Performance Tuning |
| |
| Second Week |
| Introduction to Forms |
| Object Navigator, Items, Blocks, Layout Editor, PL/SQL Editor |
| Properties, LOV & Record Group, Triggers, Built-IN Procedures, Compile |
| Form Customization, Run Form |
| Introduction to Reports |
| Object Navigator, Types of Reports, Data Model, Layout Model, Parameters |
| Properties, Report Triggers, Program Units |
| |
| Third Week(Oracle Applications) |
| Introduction to Accounting, Introduction to Oracle Applications |
| Introduction to Oracle General Ledger(GL) , Setting up Set of Books in GL |
| Entering Manual Journal Entries, Entering Reverse Journal Entries |
| Entering Recurring Journal Entries, Entering Mass Journal Entries |
| Journal Import, Journal Posting, Overview Budgeting, Overview Encumbrance |
| Account Balance Inquiry, Developing reports using FSG, Developing Journal Import process using SQL*Loader and PL/SQL packages |
| Reports in GL, Developing Custom Reports |
| Analyzing GL tables |
| |
| Fourth Week |
| Introduction to Oracle Payables (AP) |
| Entering Suppliers, Entering various types of transaction in AP |
| Transaction approval process, Running payment batches |
| Transferring data into GL, Invoice Import into AP |
| Developing Invoice Import process using SQL*Loader and |
| PL/SQL packages, Reports in AP, Developing a Custom form in AP |
| Analyzing AP tables |
|
|
| Fifth Week |
| Introduction to Oracle Receivables (AR) , Entering Customers |
| Entering various types of transaction in AR, Entering Receipts |
| Transferring data into GL, Invoice Import into AR using AutoInvoice. |
| Developing Invoice Import process using SQL*Loader and PL/SQL packages |
| Developing Autolockbox process using SQL*Loader and PL/SQL packages |
| Developing customer import process using APIs, Reports in AR |
| Analyzing AR tables |
| |
| Sixth Week |
| Introduction to Oracle Purchasing (PO) , Entering Requisitions in PO |
| Approving Requisitions, Autocreate Purchase Orders |
| Create Invoices in AP using Purchase Orders |
| Requisition Import into PO , Developing Requisition Import process using SQL*Loader and PL/SQL packages |
| Reports in PO , Analyzing PO tables |
| Workflow overview |
| |
| Seventh Week |
| Introduction to Order Management (OM) , Entering Orders in OM |
| Scheduling/Shipping goods, Sending Order delivery updates into Inventory |
| Sending Order delivery updates into AR, Developing Order Import process using SQL*Loader and PL/SQL packages, Reports in OM , Analyzing OM tables |
| Report Scheduling and Concurrent Manager |
| |
| Eighth Week |
| Introduction to Inventory (INV), Entering Item templates, Entering Items in INV |
| Item Organization, Developing Item import process using SQL*Loader and |
| PL/SQL packages |
| Developing Transaction import process using SQL*Loader and PL/SQL packages |
| Reports in INV, Analyzing INV tables, Customize Applications using custom PLL |
| Developing reports using Discoverer, Oracle documentation |
| Resume Preparation, Interview questions/answers. |
|
