Description
ORACLE APPS TECHNICAL COURSE CONTENT
- Types of Roles, Types of Projects, AIM documents
- Oracle Apps file structure, database structure and 3-tier architecture
- Application object Library
- Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities
- Menu construction, Defining concurrent program
- Concurrent program with parameters, Creating value sets, Incompatibilities
- Scheduling concurrent program, Creating request group, Creating request group, Creating request set
- Concurrent program creation using API
- 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
- General Ledger module, Creating Ledger using (Currency, Calendar and COA)
- Reports
- Report development process, Report registration process
- Bind parameters, Lexical parameters, Reports with value set, Building report manually
- Using repeating frames, Summary columns, Formula columns, Place holder column
- Standard report customisation
- Interfaces
- 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
- Conversions
- Introduction to conversions, Creation of staging table
- Developing the validation package, Explaining the real time project code.
- Completing the conversion task, Differences between Inbound interfaces and Conversions
- Forms
- Form development process using TEMPLATE.FMB, Form registration process
- Form personalization
- Using Custom.pll, Implementing ZOOM functionality
- Workflows
- Workflow Introduction, Workflow development process, running the workflow
- Sending notifications, branching the workflow using result out variable
- Creating lookup type, Creating role
- BI Publisher/XML Publisher
- Introduction to BI publisher, Report development process
- Creating reports for multiple rows, Creating Data definitions, Creating templates
- Converting standard rdf report to XML Report, Working with data templates