Oracle EBS R12 Technical Training

Course Content

• ERP Concepts
  • What is ERP?

    WHY ERP?

    ERP Vendors

    About Oracle Application & SAP

    About Oracle Application Projects
• Types Of Project
  • Implementation of Projects

    Up Gradation of 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
  • What is ERP?

    WHY ERP?

    ERP Vendors

    About Oracle Application & SAP

    About Oracle Application Projects
• 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 Report in Oracle Application with or without parameters

    Profile Option in Oracle Applications
• AIM Documentation Preparation
  • MD 70, MD120, CV 60 and TE20
    

    Reports 6i/10g in Oracle Applications

    Introduction and Usage of USER_EXITS

    Developing a Report from scratch as per Client Requirement

    Developing a Report 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 Flex fields
    

    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
• 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
• Slam
  • 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
• 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 help after getting job
• Automatic Data Optimization
  • Storage And Compression Tiering
    

    The Heat Map

    Automatic Data Optimization

    Compression Levels

    Data Dictionary Views For Ado

Course Tutorials

• Demo Videos

  • test demo Video

    Watch