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
• 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

• 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

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)
Oracle Apps (EBS) Technical Training Reviews