+91 - 9000567126, +91 - 9848686581

Oracle Apps Technical R12

BESTWAY Technologies offering  ORACLE Application R12 Technical Training in Bangalore and Hyderabad with Real time most experienced working Professionals.  Our trainer working in ORACLE APPS R12 TECHNICAL and total 13+ years experience in ORACLE Apps Technical.  we cover under this course Syllabus major topics.

  1. Application Object Library
  2. Modules Overviews
  3. Functional Cycles
  4. Reports
  5. Interfaces and Conversions
  6. .Oracle Forms
  7. Workflows
  8. Other Topics


Oracle Applications Course Content

Oracle Database (SQL and PL/SQL)
Oracle forms 10g and Reports 10g

Introduction to ERP

  • ERPs available in market
  • Types of Roles
  • Types of Projects
  • Types Instances
  • Types of AIM Documents
  • Versions of Oracle ERP
  • Oracle Applications File Structure
  • Oracle Applications Database
  • Multi Org structure
  • Types of Modules and Integration

Application Object Library

System Administrator
•Concurrent program
•Request group
•Request set

Application Developer
•Value Sets

Modules Overviews

  • Inventory Module(INV) flow with base tables
  • Accounts Payable(AP) module flow with base tables
  • Accounts Receivable(AR) module flow with base table
  • Purchasing(PO) module flow with base tables
  • Order Management(OM) module flow with base tables
  • General Ledger(GL) module flow with base tables
  • Joins between tables over across modules

Functional Cycles

  • Procure to pay(P2P) Cycle
  •  Order to Cash(O2C) Cycle


Oracle Reports

  • Report development process and registration steps
  • Building report manually with parameters
  • Using repeating frames, Anchor and USER_EXIT
  • Summary columns, Formula columns & place holder column
  • Report Triggers, Format Triggers, Bind parameters and Lexical parameters
  • Customization of standard report

XML Publisher Reports

  • Introduction to XML publisher
  • XML publisher Report development and registration process
  • Create XML publisher report with data templates
  • Converting standard RDF report to XML Report

Discoverer Reports

  • Introduction to Discoverer Reports
  • Development and Registration process of Discoverer reports

PL/SQL Reports

  • Development and Registration process of PL/SQL reports

Interfaces and Conversions

  • Introduction to Interfaces
  • Outbound Interfaces, using UTL_FILE package
  • Inbound Interface process using SQL*Loader
  • Different option in SQL *Loader tool, bad file and discard file
  • Interface Using interface tables and open interface program approach
  • Interface Using standard API Approach
  • Overview on conversions
  • Differences between Inbound interfaces and Conversions
  • Explaining the real-time project code

Oracle Forms

  • Introduction to oracle Forms
  • Form development process using TEMPLATE.fmb
  • Form registration process
  • Master details form
  • Form personalization
  • Customization Using Custom.pll
  • Implementing ZOOM functionality


  • Workflow Introduction
  • Workflow development process, running the workflow
  • Sending notifications
  • Creating lookup type, Creating role
  • Explanation of standard workflow
  • Real time Workflow development

Other Topics

  • MOAC usage
  • TCA
  • SLA
  • 11i and R12 differences


  • Request Demo

  • Add Your Review