ORACLE APP TECH

 

 

Faculty: Manoj/Gyathri

 

24 Hrs Lab, Unlimited WiFi Acess

Duration: 45 Hours

 

Demo Date:

 


Introduction to ERP

Definition of ERP, Overview of popular ERP'S

Comparison of Oracle Apps with other ERP'S

Role of an Oracle Apps technical consultant.

Types of Projects

AIM methodology.

Oracle Application Architecture.

TOAD

Pre-requisites

Application Object Library

Creating Users

WHO columns

Creating Responsibilities

Menu construction

Request group construction

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 registration

Report development overview

Report registration

Parametric report registration

Form registration

Template.fmb

Appstand.fmb

Form development using templates

Form customization concepts

Form Registration Process

Custom.Pll

Using function Zoom_available( )

Interfaces

Introduction to Interfaces

Outbound Interfaces

    - Using UTL_FILE package

Inbound Interfaces

    - Using SQL * Loader tool

Conversions

Overview on conversions

Difference between Interfaces and conversions

Working with staging table script

Developing validations package

Standards to be followed in conversions

GL and PO Conversion.

Flex Fields

Types of Flex Fields

Descriptive Flex Fields

Key Flex Fields

Workflows Overview

Introduction to workflow

Workflow builder

Attributes

Creating Processes

Sending notifications using workflows

XML Publisher

Introduction to XML Publisher

Generating XML file using reports

Creating Templates

Creating Data Definitions

Module Overview

Purchasing 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

 

MOAC Architecture in R12.

FNDLOAD utilities.

Introduction to OAF and Workflow

Introduction to emerging technologies

Case Study and Mock Interview