BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

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

Pre-Requisites
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
•User
•Responsibility
•Concurrent program
•Executable
•Request group
•Request set
•Profiles

Application Developer
•Lookups
•Messages
•Application
•Menus
•Flexfield
•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

Reports

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

Workflows

  • 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