Oracle Applications R12 Technical:

Introduction Application Object Library

Demo session - Introduction of the trainer, explaining the course contents, pre-requisities, methodology of the training.

What is ERP ? , comparasion of Oracle Apps with other ERPS

Types of Roles , Types of projects, AIM documents

Oracle Apps file structure, database structure and 3-tier architecture

Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities

Menu construction, Defining concurrent program

Concurrent program with parameters, Creating Value sets, incompatabilities

Scheduling concurrent program, Creating request group, Creating request set

Concurrent program creation using API


Module Overviews Reports

Inventory Module flow with base tables

Accounts Payable module flow with base tables

Accounts Receivable module flow with base tables

Order Management module flow with base tables

Report development process, Report registration process

Bind parameters, lexical parameters, reports with value set, Building report manually

Using repeating frames, Summary columns , Standard report customization

Interfaces Conversions

Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package

Inbound Interface process, Working with SQL*Loader tool

Different option in SQL *Loader tool, bad file, discard file

Using Interface table approach

Using API Approach

Introduction to conversions, Creation of staging table

Develoing the validation package, Explaining the real time project code.

Completing the conversion task, Differences between Inbound interfaces and Conversions

Forms Workflows

Form development process using TEMPLATE.FMB , Form registration process

Form personalization

Using Custom.pll , implementing ZOOM functionality

Workflow Introduction, Workflow development process, running the workflow

Sending notifications, branching the workflow using resultout variable