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 and SQL Developer
Module Overviews
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
Hire to Retire
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
User Management
Responsibilities
Menus
Request Groups
WHO Columns
Reports
Report development
Report registration
Parametric report registration
Reports with repeating frames
Forms
Template.fmb
Appstand.fmb
Form development using templates
Form customization concepts
Form Registration Process
Custom.Pll
Using function Zoom_available( )
Using procedure Event( )
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
PLSQL Reports and More PLSQL in Apps
How To Develop a PL/SQL report
Advantages of Developing the PL/SQL report
Coding standards to follow while developing the PL/SQL report
Usage of ERRBUF and RETCODE parameters
Usage of FND_FILE.PUT_LINE in PL/SQL
How to call a concurrent program from Backend
Workflows
Introduction to workflow
Workflow builder
Attributes
Creating Processes
Sending notifications using workflows
Workflow Administrator
XML Publisher
Introduction to XML Publisher
Generating XML file using reports
Creating Templates
Creating Data Definitions
Discoverer
Introduction to Discoverer tool
Discoverer Administrator
Creating EUL
Creating Business Areas
Discoverer Desktop
Creating work books