Oracle Apps Technical

Oracle Application Technical Course Contents (I)Introduction to ERP (i)Definition of ERP, Overview of popular ERP'S (ii)Comparison of Oracle Apps with other ERP'S (iii)Types of Roles (iv)Types of Projects (v) AIM documentation standards (vi)Oracle Application Architecture. (vii)Database structure of OA (viii) Using TOAD (II) Application Object Library (i)Creating Users (ii)WHO columns (iii)Creating Responsibilities (iv)Menu construction (v)Request group construction (III)Application development (i)Defining concurrent program (ii)Concurrent programs with parameters (iii)Working with multiple concurrent programs (iv)Scheduling the Concurrent Program (v)Concurrent Program incompatibilities (vi)Creating Request Set (vii)Procedure registration (viii)Value sets (IV)Registration of Custom Objects (i)Registration of Application (ii)Report development (iii)Report registration (iv)Parametric report registration (v)Registration of a Table (vi)Registration of Sql, Sql Loader, PL/SQL programs (IV)Interfaces (i)Introduction to Interfaces (ii)Outbound Interfaces o Using UTL_FILE package (iii)Inbound Interfaces o Using SQL * Loader tool (iv)SQL * Loader Concepts o Data File. o Control File. o Bad File. o Discard File. o Log File. o Commands in Sql * Loader o Registration Of control File in Oracle Apps. (V)Conversions 1. Overview on conversions 2. Difference between Interfaces and conversions 3. Working with staging table script 4. Developing validations package 5. Standards to be followed in conversions (VI) Flex Fields 1. Overview of flex fields 2. Types of Flex Fields o Descriptive Flex Fields o Key Flex Fields 3. Step in creation of DFF 4. Flex fields tables and relations (VII)Profiles 1. Overview of profile options 2. Different levels in Setting profiles 3. Steps in setting a profile option 4. Some important profile options 5. Some important API’s of profiles (VIII) Value sets 1. Overview of value sets 2. Options in value sets 3. Types of value sets 4. Creation of value set 5. Overview of value set tables (IX)Multi Org Concepts (i) What is Multi Org and why we need. (ii) Multi Org Tables. (iii) Multi Org Views. (X) PO Overview and tables (i) Overview of purchasing (ii) Major setups and transactions (iii) Overview of some purchasing tables (XI)INV Overview and Tables • Overview of inventory (i) Major setups and transactions (ii) Overview of some INV Tables (XII)OM Overview and Tables (i) Overview of order management (ii) Major setups and transactions (iii) Overview of some Order Management Tables (XIII) GL Overview and Tables (i) Overview of GL (ii) Major setups and transactions (iii) Overview of some GL tables (XIV) AP Overview and tables 1.Overview of payables 2. Major setups and transactions 3. Overview of some payable tables (XV) Form personalization 1. Forms personalization: need and benefits 2. Use validate feature to confirm conditions and strings 3. Form Personalization v/s Form Customization (XVI)Alerts 1. Overview on alerts 2. Types of alerts 3. Creation of alerts (XVII) XML Publisher 1. Introduction to XML Publisher 2. Generating XML file using reports 3. Creating Templates 4. Creating Data Definitions