Training

R12 Oracle Financials(GL, AP, AR)

Introduction to Oracle EBS

1. Overview of Oracle EBS
2. Navigating the Application
3. Basic concepts of Oracle EBS

   Multi-Org Structure

   Flex-Fileds (Key and DFF)

4. Defining the Users and Responsibilities

General Ledger

1. Overview of GL Processes
2. Learning all the Setup requiirements for the GL Processes
3. GL Transactions with Hands-On

   Manual Journals

   Journal Batches

   Recurring Journals

   Budget

   AGIS - Advanced Global Inter-Company System

   Subledger Accounting

   Security and Security Access

Accounts Payables

1. Overview of Payables Processes
2. Learning all the Setup requirements for the Payables Processes
3. PayablesTransactinos with Hands-on

   Suppliers and Supplier Site

   Entering Invoices

   Matching the invoices with PO documents

   Validate, Create Account the invoice

   Enter the Payments

   Apply the Payments with the invoices

   Transfer to GL

   Reconcile the transaction in GL

   AP/AR Netting

   Retention

Accoutns Receivables

1. Overview of Receivables Processes
2. Learning all the Setup requirements for the Receivable Processes
3. Receivable Transactions with Hands-On

   Customers

   Enter Manual invoices, Credit Memo, Debit Memo

   Enter Deposits and apply deposits

   AR- Late Charges

   Enter Receipts

   Transfer to GL

   Reconcile the transaction in GL

Duration : 10 days

R12 Oracle Financials with FSG,

Period Closure, DBI Reports and Web ADI

General Ledger

1. Overview of GL Processes
2. All Setup requiirements for the GL Processes
3. Running the GL Transactions with Exercise

   Manual Journals

   Journal Batches

   Recurring Journals

   Budget

   Subledger Accounting

Accounts Payables

1. Overview of Payables Processes
2. All Setup requirements for the Payables Processes
3. Running the PayablesTransactinos with Exercise

   Suppliers and Supplier Site

   Entering Invoices

   Matching the invoices with PO documents

   Validate, Create Account the invoice

   Enter the Payments

   Apply the Payments with the invoices

   Transfer to GL

   Reconcile the transaction in GL

Accoutns Receivables

1. Overview of Receivables Processes
2. All Setup requirements for the Receivable Processes
3. Running the Receivable Transactions with Exercise

   Customers

   Enter Manual invoices, Credit Memo, Debit Memo

   Enter Deposits and apply deposits

   Enter Receipts

   Transfer to GL

   Reconcile the transaction in GL

   AR- Late Charges

Financial Statement Generator (FSG)/Web ADI/ PC

1. FSG

   Developing the Financial Reports using FSG

2. Period Closure

   Period Closure for AP

   Period Closure for AR

   Period Closure for GL

3. Web ADI

   Overview of Web ADI tools

   Exporting Journals to GL

   Exercise using Web ADI

DBI Reports

1. Setup Requirements for DBI Reports in Financials
2. Overview of Standard DBI Reports
3. Customize the Standard DBI Reports
4. Develop a simple DBI Reports

Duration : 5 days

Oracle Apps DBA with RAC and Data Guard

Cluster Concepts

1. What is a Cluster
2. Why do we need a Cluster in Real Time
3. Advantage and Benefits of Cluster

Oracle 10g RAC Architecture

1. RAC Concept and Architecture
2. RAC Architecture with E-business Suite
3. RAC Architecture with core Application

RAC Pre-Installation Configuration on Cluster Nodes

1. Oracle OS user and group creation
2. OS /etc/hosts entries - Public, Private and Virtual IP address
3. OS .rhosts enable for Oracle and root users
4. Enable rcp and ssh on both cluster Node
5. Make necessary OS related changes as prescribed by Oracle
6. Ping, rcp and ssh test on both cluster nodes
7. Add entry in /etc/hosts.equiv of Cluster nodes to root and oracle user
8. Creating voting and OCR files on the cluster shared mount point

OCFS Installation on SAN (Storage Device)

1. Download Software OCFS2
2. Check for SAN with required disk space
3. Install the OCFS 2
4. Configure
5. O2CB Cluster services Enable
6. Formating Disks using OCFS2 Console
7. Create Mount points and mount the same
8. Tune
9. File system checks
10. Post configuration check using mounted.ocfs2 utility

Oracle 10g RAC Installation

1. Clusterware installation
2. RDBMS Installation
3. Upgrade both CRS and RDBMS for the latest version
4. Create Database based on the application specific sizing
5. Create ASM instance on SAN
6. Create diskgroup for ASM on SAN
7. If for E-business suite need to follow the steps for converting into RAC

Oracle 10g RAC Post Installation

1. Check all the services are running using on both nodes - crs_stat -t
2. Check all the database are up and running by login from both nodes
3. Check by login through the application
4. Stop all the service and reboot the server and restart all the services

Introduction to Data Guard

1. What is Data Guard
2. Why do we need to have a Data Guard
3. Benefits and Advantage of Implementing Data Guard

Pre Data Guard Setup activity

1. Have a separate server with all the pre-requisites for Data Guard Setup
2. Ensure Primary Database in Archivelog mode
3. Take a backup of the Primary database
4. Create the standby control file from Primary Database
5. Copy files to the Standby Server
6. Set the initialization parameters for the primary database

Data Guard Setup on the Standby Server

1. Create same directory structure as the primary database on the Standby server
2. Copy DB TOP or install the same Enterprise Edition RDBMS
3. Create a Backup Copy of the Primary Database Datafiles
4. Copy the primary database parameter file to the standby database server
5. Set Up the Environment to Support the Standby Database
6. Configure listeners for the standby database
7. Start the physical standby database in a READ ONLY Mode
8. Create a new temporary file for the physical standby database
9. Start Redo Apply
10. Test archival operations to the physical standby database

Post Data Guard Setup on the Standby Server

1. Verify the Physical Standby Database Is Performing Properly
2. Identify the existing archived redo log files
3. Force a log switch to archive the current online redo log file
4. Verify the new redo data was archived on the standby database
5. Verify new archived redo log files were applied

Duration : 10 Days

Purchasing,iProcurement with AME

workflow

Purchasing

1. Overview of Procure to Pay Process Flow
2. Suppliers, Approved Suppliers and Sourcing Rules
3. Basic Setups Related to Locations, Multi-Org, Items and UOM
4. All Setups requirments to run the Purchasing Processes
5. Purchasing Processes with excercises
6. RFQ and Quotations
7. Requisitions
8. AutoCreate Documents
9. Blanket Purchase Agreements and Releases
10. Purchase Orders
11. Receiving
12. Returns
13. Employee, Job, Position and Postion Hierarchy
14. Approval Routing (Groups and Assiggment)
15. Quick Codes for Purchasing

iProcurement

1. Overview of iProcurment Process Flow
2. Setup Requirements for iProcurement Application Processes
3. iProcurement Processes with exercise

   iProc Requisitions

   Autocreate iProc Requisitions into PO documents

   iProc Desktop Receiving and Retruns

4. iProcurement Catalog Administrator

   Create Stores and link to Content Zones

   Local Internal Catalog

   Punchout

   Transparent Punchout

   Create Smart Forms and Use

   Schema Maintenance

   Item Categories

   Category hierarchy

   Category Mapping

   Agreements Export into iProcurement

Oracle Approvals Management (AME)

1. Overview of Oracle Approvals Management
2. Integration with iProcurement
3. Basic Concept of Oracle Approvals Management
4. Setups requirements for a given Business Scenario
5. Attributes
6. Conditions
7. Action Types
8. Approver Groups
9. Rules
10. Generate Approvers List based on the AME Setup
11. Test Workbench
12. Modifying the workflow for Reminder Notifications

Duration : 5 Days

Advanced Oracle Applications Technical

XML Reports

1. Oracle Reports and Customization
2. Overview of XML Reports
3. Develop the XML Reports
4. Adding the multi-Lingual feature

Oracle Workflow

OA Frame Work

1. Personalization
2. Extentions

Duration : 6 Days

Overview course on BPEL and ESB

BPEL/ESB

1. Building BPEL Processes
2. Building the ESB Processes
3. Deploying the Processess
4. Execution and Monitoring the Processes

Duration : 5 days

OA Frame Work

OA Frame Work

1. Customizing the Oracle Web Page
2. Personalization
3. Extentions

Duration : 5 days