Oracle Apps Technical Training Training

Definition of ERP, Overview of popular ERP’S

Comparison of Oracle Apps with other ERP’S

Types of Roles

Types of Projects

AIM documentation standards

Oracle Application Architecture.

Database structure of OA

Using TOAD

Application Object Library

Creating Users

WHO columns

Creating Responsibilities

Menu construction

Request group construction

Registration

Table Registration

Table Registration using AD_DD package

View Registration

Sequence Registration

New Application/New Module Development

Form Registration

Form Functions

Non-Form Functions

Report Registration

Registration of SQL*Plus files

Registration of SQL*Loader files

Registration of PL/SQL procedure

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

Application development

Defining concurrent program

Concurrent programs with parameters

Working with multiple concurrent programs

Scheduling the Concurrent Program

Concurrent Program incompatibilities

Creating Request Set

Procedure registration

Value sets

Reports

Report development

Report registration

Parametric report registration

Reports with repeating frames

Module Overviews

Accounts Payable module flow with base tables

Accounts Receivable module flow with base tables

Order Management module flow with base tables

Purchase order Module flow with base tables

General Ledger Module flow with base tables

Interfaces

Introduction to Interfaces

Outbound Interfaces

– Using UTL_FILE package

Inbound Interfaces

– Using SQL * Loader tool

Conversions

Flex Fields

Overview on conversions

Difference between Interfaces and conversions

Working with staging table script

Developing validations package

Standards to be followed in conversions

Types of Flex Fields

– Descriptive Flex Fields

– Key Flex Fields

Value sets

Overview of value sets

Options in value sets

Types of value sets

Creation of value set

Overview of value set tables

XML Publisher

Introduction to XML Publisher

Generating XML file using reports

Creating Templates

Creating Data Definitions

Workflow

Introduction to workflow

Workflow builder

Creating Processes

Discoverer

Introduction to Discoverer tool

Discoverer Administrator

Creating Business Areas

Discoverer Desktop

Creating work books

P2P (procure To pay) Bussiness Flow(Tables Explaination)

O2C (Order To Cash) Bussiness Flow(Tables Explaination)