Oracle Application R12 Technical
Cost of training: INR 20,000
Duration: 40 Hrs

Introduction to Oracle ERP

  • Definition of ERP

  • Overview of popular ERP’S

  • Comparison of Oracle Apps with other ERP’S

  • AIM documentation standards

  • Oracle Application Architecture.

  • Database structure of OA

Oracle Application R12

  • 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, incompatibilities

    • Scheduling concurrent program, Creating request group, Creating request set

    • Concurrent program creation using API

  • Module Overview :

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

    • CReport 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 :

    • Intoduction to conversions, Creating of staging table

    • Developing the validation package, Explaining the real time project code

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

2015-2016, All Rights Reserved

A part of the NS2 Group