ORACLE APPS TECHNICAL USA IN INDIA

Oracle Applications Technical Training Content @Sadguru Technologies-: 1. Brief Introduction about Oracle Applications. i. Different roles for the consultants ii. Types of Projects we usually get iii. Apps Database Architecture 2. About System Administrator Responsibility i. Creation of User, Responsibility, Executable and Concurrent program ii. About Flexfields (Key and Descriptive Flexfields) iii. Creation of Request Group, Request set, Value Set 3. Creation of an Oracle report i. Create report using Report Builder ii. Define this report as a Concurrent Request iii. Migrating this report from one instance to other instance using FND LOAD 4. P-P Cycle i. Create Requisition, Purchase Order ii. Create Receipt, Payable Invoice and Pay the Invoice. iii. Transfer to GL 5. O-C Cycle i. Create Sales Order, Pick Release and Ship Confirm ii. Create Receivable Invoice, receipt and Apply the receipt iii. Transfer to GL 6. What is the use of an Interface and Conversion and the differences between them. Ø About Interface: i. Create Loader Program using sql*Loader (To load the data from flat file to a dummy table) ii. Write a plsql package to validate staging data and register this package as a request iii. Now Load the data from Staging table to Interface tables. Ø About Conversion: Ø Different ways to load data from flat file to Base Tables (Interfaces and Using API’s) 7. Purpose of XML Reports i. How to create an XML report Data definition ii. Create an XML Data Template iii. Different ways to Create an XML Report (Using Oracle Reports and XML Data templates) 8. About Form Personalization and Customization using Custom.pll i. Different examples ii. Migration of personalization. iii. Personalization on OAF Page