Overview

•Oracle Database is used to manage resources (Data) efficiently by performing backup, recovery, tuning, auditing etc…

•Organization working on multiple technologies prefers Oracle as Database which is compatible with windows and Linux platforms providing High Level of security.

•Course is oriented for getting professional training on Oracle Application giving full fledged knowledge on managing Database independently.

Pre-requisites

•Knowledge in SQL, Pl/Sql and Linux.

Applications

Course Brochure

Peers Technologies Pvt. Ltd.

Oracle Application

Page 1

COURSE CONTENTS

ORACLE APPS TECHNICAL

Introduction to ERP

Definition of ERP Overview of popular ERP'S Comparison of Oracle Apps with other

ERP'S AIM documentation standards Oracle Application Architecture. Database structure of OA Using TOAD

Types of Projects

Implementation Projects Upgradation Projects

Supporting Project Customization Project

Types of Roles

Functional Consultant & Roles Technical Consultant & Roles

Techno-Functional Consultant & Roles

Oracle Application DBA & Roles

Application Object Library

System Administration and Application Object Library (AOL)

Defining an Applications User and Assigning the Responsibilities.

Understanding AOL and its Components WHO columns Creating Responsibilities

Request group creation

Menu Creation

Application Development

Defining concurrent program Concurrent programs with parameters

Working with multiple concurrent programs Scheduling the Concurrent Program Concurrent Program incompatibilities Creating Request Set Default Types Value sets Messages

Lookups

Registration of Custom Objects

Report registration Registration of a Table

Registration of Sql, Sql Loader, PL/SQL programs and Host Scripts

Using AD_DD Package to register

Database Component in AOL

Interfacesand Conversions

Introduction to Interfaces Difference Between Interfaces and

Conversions Outbound Interfaces

o Using UTL_FILE package Inbound Interfaces

o Using SQL * Loader tool SQL * Loader Concepts

o Data File. o Control File. o Bad File. o Discard File. o Log File.

o Commands in Sql * Loader o Registration Of control File in Oracle

Apps.

Page 2 Oracle Application

COURSE CONTENTS

Working with staging table script Developing validations package Standards to be followed in conversions Using oracle API’s in Interfaces and

Conversions

Interface Tables and Error Tables

Flex Fields

Overview of flex fields Types of Flex Fields

o Descriptive Flex Fields o Key Flex Fields

Step in creation of DFF Flex fields tables and relations

Profiles

Overview of profile options

Different levels in Setting profiles Steps in setting a profile option Some important profile options

Some important API’s of profiles

Value sets

Overview of value sets Options in value sets Types of value sets Creation of value set Overview of value set tables

Usage of $FLEX and $PROFILE

Multi Org Concepts

What is Multi Org and why we need. Multi Org Tables.

Multi Org Views.

Functional Modules Overview

Overview of Procure to Pay Flow (P2P Cycle)

Overview of Order to Cash Flow (O2C Cycle)

Major setups and transactions

Overview of important tables in

PO,INV,OM,AP,AP,GL

Reportsin Oracle Applications

Introduction and Usage of USER_EXITS. Developing a Report from scratch as per

Client Requirement. Developing a Report based on MD 50

Document. Customization of Oracle Standard Reports. Reports Registration Steps in Oracle

Applications

Standards to develop a report in Oracle Apps

Multi-Language Report Development

Reports with Barcode

Formsin Oracle Applications

New Form Development Process Form Registration in Oracle Applications

Calling one Form to another form by

using Button

Master-Detailed Forms Form Personalization in Oracle Apps

Form Personalization v/s Form

Customization

Page 3 Oracle Application

COURSE CONTENTS

Alerts

Overview on alerts Types of alerts Creation of alerts

XML Publisher

Introduction to XML Publisher Difference between XML Publisher Report

and Oracle Reports 6i Generating XML file using reports Creating Templates Creating Data Definitions Registration of XML Publisher Reports in

Oracle Applications

Introduction to Linux and basic Linux

Commands

Real Time Projects and FAQ’s in

Oracle Apps

ORACLE APPS FUNCTIONAL

Introduction to ERP

Introduction to ERP What is oracle What is Oracle Application/E-Business

suite

Versions available in Oracle Versions available in Oracle Application What are major modules available in

Oracle Application ERP’s available in the market Why Oracle application is so popular What Basically Implementation, up

gradation & Support is? Overview of Implementation of Oracle

Application Companies Implementing Oracle

Application Hardware requirements for Oracle

Application

Oracle General Ledger

Introduction Calendars Flex Fields

Accounting Flex Fields GL Ledger Flex Feilds

Chart of accounts Account Setup Manager

Define Legal Entity Define Ledgers Define Accounting Options

Add Legal Entities to Ledgers Assign BSV to Legal Entities

Ledger Sets Definition Access Sets Auto Copy Journals Reversal Journals

Manual Reversal Auto Reversal

Page 4 Oracle Application

COURSE CONTENTS

Suspense Journals Recurring Journals

Standard Skeleton Formula

Mass Allocation Journals Inter Company & Intra Company Journals

Without Qualifying Method With Qualifying Method

Reporting Currency Ledgers Balance Method Journal Method Sub Ledger Method Adjustment Only

Revaluation Process Posting Method

Manual Batch Posting Auto Posting

Consolidation Workbench Budgets Summary of Accounts Period Close Process

Document Sequence About Security Rules About Cross Validation Rules Financial Statement Generator (FSG) Journal Approval Process

Oracle Purchasing

MOAC Setups Define Locations Define Business Group Define Operating Units Define Security Profile

Define HR Organization Define Security & User Access Define Purchasing Options Define Jobs Define Positions Define Employees Define Employee/Position Hierarchies’

Define Buyers Define Approval Groups Approval Group Assignments

Process Setup Define Master Item Create Requisition Define Suppliers Create Requisition ,RFQ,

Quotations & Purchase Order Creating Receipts

Self Billing Invoices (Auto Invoices) Create Document Style Create Complex Work Order Create Accounting Returns Receiving Option Copy Document Auto Create Close/Cancel PO Requisition

Oracle Payables Module

MOAC Setup

Define Financial Option Define Payable Options Invoice Work Bench

Standard Debit Memo Credit Memo Mixed Invoices

Pre Payments Retain Age Release Expenses Report With Holding Tax Invoices Interest Invoices Recurring Invoices Define Grants & Roles (User

Management) Define Banks Define Branches Define Bank Accounts

Define Payable Documents Define Organization Access Define Payables Controls

Define Reconciliation Controls

Page 5 Oracle Application

Oracle Application

COURSE CONTENTS

Payment Workbench Manual Payments Quick Payments Bills Receivables Refund Payments

Period Close Process Holds

Manual Hold System Hold

Invoice Matching with P.O Quick Match (P.O) Corrections Payment Terms Distribution Set

Full Type Skeleton

Cancellation Of Invoice

Oracle Payments(ipayments)

System Security Options

XML Publisher Format Template Payment Format Payment Methods Payment Method Defaulting Methods Payment Process Profile Payment Manager

Fixed Assets

Flex Fields

Category Flex Fields Asset Key Flex Fields Locations Flex Fields

Define System Controls Define Fiscal Years Define Calendars

Depreciation Calendar Prorate Calendar

Define Prorate Convention Define Depreciation Methods

Define Asset Categories

Define Asset Books Asset Additions

Mass Addition Quick Addition Manual Addition

Run Deprecation Mass Retirement Asset Revaluation Mass Changes

Mass Transfer Asset Re-Classifications Create Accounting Tax Book Amortization and Cost Adjustment Split and Merge What If Analysis Projections CIP Assets Transferring Assets JE to GL

Receivables Module

Introduction to Receivables MOAC Setups For Receivables Configuring System Options Introduction To TCA TCA Setups

Customers Parties Organizations

Relationships Auto Accounting Transaction Types Transaction Batch Sources Document Sequencing Transaction Work Bench

Invoices Credit Memo Debit Memo Deposits

Guarantee Chargeback Bills Receivables

Receivables Activities Define Receipt Class

Page 6 Oracle Application

COURSE CONTENTS

Manual Receipts Receipt with Auto Cash Rule Sets Receivables transfer to General Ledger

Period Close Process

EBT(Enterprise Business Taxes)

Geography Codes Tax Regimes Taxes

Tax Statuses Tax Jurisdiction Tax Rates Tax Rules Application Tax Options Configuration Tax Options

Create Tax Party Profile Create Party Tax Profile For Third Parties Recoverable Tax Non-Recoverable Tax

Sub Ledger Accounting Method (SLAM)

Event Entities Event Classes Event Types Process Categories Sources Mapping Sets

Journal Entry Description Journal Line Type Journal Line Definitions Application Accounting Definitions Sub Ledger Accounting Methods Customizing SLA

Cash Management

MOAC for Cash Management Define System Parameters Manual Reconciliation Bank Transfers

Cash Forecasting

Procure To pay Cycle Order To Cash Cycle Fixed Assets To General Ledger Cycle

System Administration

Define Application User Control Application User Assign Responsibility to the User Control Responsibility

Setup Menu and Function Setup Profile for Monitoring Application User Monitoring Application Users Define Responsibility Update System Profile Options Define Concurrent Program Define Concurrent Program Executables Define User Define Application

Implementation Life Cycle Documentation Using AIM and ABF

Methodology

AS-IS Document BP40 (Recording Present Condition of Client)

TO-BE Documents BP80,BR30 (Eventual Outcome-(Final Condition))

RD20 Module Design Document MD050, MD070.

Conversion Document CV40, CV60 Testing Document.

Table Flow

Procure To Pay

Order To Cash

Page 4 Oracle Application

Page 7 Oracle Application