Oracle Applications R12 Technical
Course Description
Â
 | Introduction | ||
Session 1 | Demo session - Introduction of the trainer, explaining the course contents, | ||
Session 2 | Types of Roles , Types of projects, AIM documents | ||
Session 3 | Oracle Apps file structure, database structure and 3-tier architecture | ||
 | Application Object Library | ||
Session 4 | Levels of Oracle Applications, Creating users, WHO columns, | ||
Session 5 | Menu construction, Defining concurrent program | ||
Session 6 | Concurrent program with parameters, Creating Value sets, incompatibilities | ||
Session 7 | Scheduling concurrent program, Creating request group, Creating request set | ||
Session 8 | Concurrent program creation using API | ||
 | Module Overviews | ||
Session 9 | Inventory Module flow with base tables | ||
Session 10 | Accounts Payable module flow with base tables | ||
Session 11 | Accounts Receivable module flow with base tables | ||
Session 12 | Order Management module flow with base tables | ||
Session 13 | General Ledger module , Creating Ledger using ( Currency, Calendar and COA ) | ||
 | Reports | ||
Session 14 | Report development process, Report registration process | Â | |
Session 15 | Bind parameters, lexical parameters, reports with value set, Building report manually | Â | |
Session 16 | Using repeating frames, Summary columns , Formula columns, place holder column | Â | |
Session 17 | Standard report customization | Â | |
 | Interfaces |  | |
Session 18 | Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package | Â | |
Session 19 | Inbound Interface process, Working with SQL*Loader tool | Â | |
Session 20 | Different option in SQL *Loader tool, bad file, discard file | Â | |
Session 21 | Using Interface table approach | Â | |
Session 22 | Using API Approach | Â | |
 | Conversions |  | |
Session 23 | Introduction to conversions, Creation of staging table | Â | |
Session 24 | Developing the validation package, Explaining the real time project code. | Â | |
Session 25 | Completing the conversion task, Differences between Inbound interfaces and Conversions | Â | |
 | Forms |  | |
Session 26 | Form development process using TEMPLATE.FMB , Form registration process | Â | |
Session 27 | Form personalization | Â | |
Session 28 | Using Custom.pll, implementing ZOOM functionality | Â | |
 | Workflows |  | |
Session 29 | Workflow Introduction, Workflow development process, running the workflow | Â | |
Session 30 | Sending notifications, branching the workflow using result out variable | Â | |
Session 31 | Creating lookup type, Creating role | Â | |
 | BI Publisher / XML Publisher |  | |
Session 32 | Introduction to BI publisher, Report development process | Â | |
Session 33 | Creating reports for multiple rows, Creating Data definitions, Creating templates | Â | |
Session 34 | Converting standard rdf report to XML Report, Working with data templates | Â | |
 | Flex fields |  | |
Session 35 | Customizing DFF, Creating KFF | Â | |
 | Functional Cycles |  | |
Session 36 | P2P Cycle | Â | |
Session 37 | O2C Cycle | Â | |
 |  |  |  |
Â