Introduction
Demo session - Introduction of the trainer, explaining the course contents, pre-requisities, methodology of the training.
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, incompatabilities
Scheduling concurrent program, 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 customization
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
Develoing 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 resultout variable
XML Publisher
Introduction to XML 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
Discoverer
Introduction to Discoverer tool, Using Discoverer Administrator, Creating EUL, Creating Business Areas
Creating Joins, Creating Item class, Using Discoverer Desktop, Creating workbooks, Discoverer report registration process
Flex fields
Customizing DFF, Creating KFF
Functional Cycles
P2P Cycle
O2C Cycle.
* Resume preparation and Interview assistance will be provided.
For any further details please
contact India +91-9052666559
USA : +1-678-693-3475.
visit http://www.magnifictraining.com/oracle-scm-online-training/