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