+91-80999 02123201-710-8393

Oracle Apps R12

ERP Concepts

  • What is ERP?
  • WHY is ERP?
  • ERP Vendors.
  • About Oracle Application & SAP.
  • About Oracle Application Projects

Types of Project

  • Implementation Projects.
    • Up Gradation Projects.
    • Supporting Project.
    • Rollout Project

    Oracle Application Positions Hierarchies.

    • Functional Consultant & Roles .
    • Technical Consultant & Roles.
    • Techno- Functional Consultant & Roles.
    • Oracle Application DBA & Roles
    • Oracle Applications 11i/R12 Architecture
    • Three Tier Architecture Components.

    Oracle Application 11i/R12 File system .

    • System Administration and Application Object Library (AOL)
    • Defining an Applications User and Assigning the Responsibilities.
    • Understanding AOL and its Components

    Using AD_DD Package to register Database Component in AOL.

  • Registering Custom Concurrent Programs based on Reports, Sql scripts, PL/SQL Stored Procedures.
  • Registering a Custom Reports in Oracle Application with or without parameters.
  • Profile Option in Oracle Applications.

AIM Documentation Preparation.

  • MD 70,MD120,CV 60,TE20
  • Reports 6i/10g in Oracle Applications
  • Introduction and Usage of USER_EXITS.
  • Developing a Report from scratch as per Client Requirement.
  • Developing a Reports based on MD 50 Document (Reports in GL, AP, PO, INV).
  • Multi-Org & MOAC Concepts in Oracle Application 11i/R12
  • Customization of Oracle Standard Reports.

Flex fields and Value Sets.

  • Flex Fields and Types of Flexfeilds
  • Value Sets and Types of Value Sets.
  • Usage of $FLEX and $PROFILE.

Oracle Application Interface

  • Inbound Interface
  • About Interface and Scenarios.
  • Interface Tables and Error Tables
  • Sql * Loader
  • Standard Gl Interface and Po Requisition.
  • Writing Validation Programs
  • Outbound Interface


  • Difference between Conversion / Interface/ Data Migration.
  • Conversion Approach.
  • Interface Table Approach (OIT).
  • API's Approach.
  • Direct Insertions
  • Conversion Package Standards.
  • Set Defaults, Validation Procedure, Loading Procedure and Error Report.
  • Item Conversion and Vendor Conversion based on CV 40 Document.
  • Customer Conversion using API Approach.
  • Lot Number Conversion Using API Approach.
  • Data Migration/Data Extractions
  • Extracting data from source Instance to Repository Instance.

Functional Concepts.

  • Procure To Pay Life Cycles
  • Order to Cash Cycles.
  • FA To General Ledger Cycles.
  • Technical Data Flow from Front End to Back End.


  • About Sub Ledger Accounting (SLA).
  • TCA in R11i and R12i
  • Banks, Suppliers
  • Tables in R12i and R11i
  • General Ledger in R11i and R12i. with tables.
  • About Multi-Org Access Control.
  • MOAC Reports.

XML Publisher.

  • Difference between XML Publisher Report and Oracle Reports 6i/10g/11g.
  • About XML Publisher Report and Template Builder.
  • Creation of New Report in XML Publisher
  • Registration of XML Publisher Reports in Oracle Applications.
  • Template features
  • Conditional Formatting.
  • Sub Template
  • IF Condition
  • IF THEN ELSE condition
  • Oracle Discoverer 10g

Discoverer Administrations.

  • Introduction of Discoverer.
  • Discoverer VS Reports.
  • Creation of EUL
  • Defining a New Business Area .
  • Creation of Folders & Custom Folders.
  • Creations of Items.
  • Creation of pages.
  • Registration of Functions.

Discoverer Desktop

  • Work Book Creation
  • Creation of Work Sheet
  • Work Book Registration in apps
  • Calculations, Defining totals and Sub totals.
  • Defining Parameters.
  • Multiple Parameters.
  • Grouping The Records, Edit Sheet , Invoking functions
  • Joining Conditions with Tables in Discoverer.
  • Exception
  • Worksheet Generation

Oracle Apps Forms

  • Work Discoverer Desktop
  • Form registration
  • Template.fmb
  • Appstand.fmb
  • Form development using templates
  • Form customization concepts
  • Form Registration Process
  • Custom.Pll
  • Using function Zoom_available( )
  • Using procedure Event( )
  • Real Time Live Project
  • Implementation Methodology and Supporting Process
  • Real Time Reports/Interface/conversion/Customization
  • SQL and PLSQL Performance Methodology
  • Covering Oracle Financials +Oracle India Localization Financials
  • 100% Placement assistance
  • Mock Interviews and FAQ's
  • Resume Preparation
  • Real Time helps after getting job.


#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings


The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment


I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment

Mushtak Shaik