ORACLE Apps R12 Technical

Oracle Applications

Business Flow
E-Business Suite
ERP
  • Available  ERP’s in the Market
  • Business Flow in ERP
Types of Roles
Types of projects
AIM Documents
Multi Org
Profile Options
Flex Fields
  • Introduction to Descriptive Flex fields
  • Customization of DFF’s
  • Base Tables for DFF’s
  • Introduction to Key Flex Fields
  • Defining KFF’s
  • Customization of KFF’s
  • Base Tables of KFF’s
Value Sets
  • Introduction to Value Sets
  • Type of Value Sets
  • Defining Value Sets
  • Base Tables of Value Sets
Application Objects Library
  • Creating a new user
  • Defining responsibilities
  • Attaching responsibilities to the user
  • Defining Executable
  • Defining Concurrent Programs
  • Defining Request Groups
  • Calling Concurrent Programs from SRS window

 

v  Modules Overview

Inventory
  • Functional Overview of Inventory
  • Base tables with join conditions
  • Preparing Queries as per the requirement
Purchase Orders
  • Functional Overview of Purchase Orders
  • Base tables with join conditions
  • Preparing Queries as per the requirement
Order Management
  • Functional Overview of Order Management
  • Base tables with join conditions
  • Preparing Queries as per the requirement
Account Payable
  • Functional Overview of Account Payables
  • Base tables with join conditions
  • Preparing Queries as per the requirement
Account Receivable
  • Functional Overview of Account Receivables
  • Base tables with join conditions
  • Preparing Queries as per the requirement

 

v  RICE Components

Reports
  • Introduction to Reports
  • Reports Components
  • Report Development using wizard method
  • Developing  Reports manually
  • Using Triggers
  • Using summary column, formula column and place holder column
  • Building report using parameters
  • Building Reports using value sets
  • Moving Report from local machine to server machine
  • Registering Report with Oracle Apps
  • Registering reports with different executable methods
  • Calling register report from SRS window
  • Customization of standard reports
Interfaces
  • Introduction to Interfaces
  • Working with Outbound Interfaces
  • Working with Inbound interface process
  • Using SQL * Loader
  • Interface/Conversion Tables
  • Working with API’s
  • Real Time Code Explanation
Conversions
  • Difference between Interfaces and Conversions
  • Introduction to Conversions
  • Creating staging tables
  • Developing the Validation Package
  • Interface/Conversion Tables
  • Standard Interface/Conversion Programs
  • Real Time Code Explanation

 

v  XML Publisher/ BI Publisher

  • Introduction to XML Publisher
  • Report Development Process
  • Creating  BI Publisher Report through .rdf report
  • Generating XML file through a concurrent program
  • Generating XML file from an standard rdf report
  • Defining Data Definitions
  • Defining Templates
  • Customization of existing BI Reports

 

Quick Contact