ORACLE TECHNICAL

ORACLE APPS R12 TECHNICAL TRAINING

 Course Duration: 40 Hours  

Course content                                                                     

Introduction to ERP
»  Definition of ERP, Overview of popular ERP’S
»  Comparison of Oracle Apps with other ERP’S
»  Types of Roles
»  Types of Projects
»  Oracle Application Architecture.
»  Database structure of OA
»  Using TOAD

Application Object Library
»  Creating Users
»  WHO columns
»  Creating Responsibilities
»  Menu construction
»  Request group construction
»  Print setups
»  Multi organization structure

Application development
»  Defining concurrent program
»  Concurrent programs with parameters
»  Creation of Executable (oracle reports, plsql stored procedures, host,sql*plus,sql*loader)
»  Working with multiple concurrent programs
»  Scheduling the Concurrent Program
»  Concurrent Program incompatibilities
»  Creating Request Set
»  Procedure registration
»  Value sets

Reports registration
»  Report development
»  Report registration
»  Parametric report registration
»  Reports with repeating frames 

Module Overviews
»  Inventory Module flow with base tables
»  Order Management module flow with base tables

Form Customization & Personalization
»  Template.fmb
»  Appstand.fmb
»  Form development using templates
»  Form customization concepts
»  Form Registration Process
»  Custom.Pll

Interfaces
»  Introduction to Interfaces
»  Outbound Interfaces
»  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

Flex Fields
»  Types of Flex Fields
»  Descriptive Flex Fields
»  Key Flex Fields

Workflows
»  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

AIM Methodology :
»  Documentation Preparation (Technical, function, migration documents)
»  AIM documentation standards
»  Business Flow (Tables Explanation)
»  Project Explanation
»  Assigning Real time Tasks.
»  RESUME Preparation

Our Courses