Greens Technology
15 First Street Padmanabha Nagar, Adyar, Chennai
      Greens Technology Contact
Email: contact@greenstechnologys.com

Oracle Apps Technical Training in Chennai


Best Oracle Apps Technical Training in Chennai location with experienced, real-time trainers with real-time scenarios.


SQL, PL/SQL, Forms & Reports, Work Flow Builder, XML Publisher, AOL (Appl. Obj Library)

Advanced Concepts

Reports
Web Reports
Data Model Objects
Layout Objects
Parameter Form Objects
PL/SQL
Templates
Output Formats and Capabilities
Data Sources
Debugging Tools


Introduction to Oracle Applications

    Role of Technical Consultant

    Architecture:

    • Architecture of Oracle Application Package
    • Product Directory Structures
    • Users
    • Responsibilities
    • Role of Apps Database User
    • File Objects in Oracle Applications
    • Database objects in Oracle Applications
    • Profile Options

    Registration:

    • Table Registration
    • Table Registration using AD_DD package
    • View Registration
    • Sequence Registration
    • New Application/New Module Development
    • Form Registration
    • Form Functions
    • Non-Form Functions
    • Basic Report Registration
    • Parametric Report Registration
    • Registration of SQL*Plus files
    • Registration of SQL*Loader files

    Report Development:

    • Customization of Reports – Adding DFF Info
    • Customization of Reports – Removing Parameters
    • Flexfield Report with Single Structure

    Interface Development:

    • Interface Scenarios
    • Usage of Standard Import Programs
    • Daily Rates Import
    • GL_Interface

    Up-gradation:

    • O2C Cycle Overview
    • OM Setups
    • Forms Up-gradation
    • Reports Up-gradation
    • Menus Up-gradation

    XML Publisher:

    • Introduction
    • Generating XML File through Report Builder
    • Creating a Template
    • Generating RTF Output
    • Register XML Report in APPS

    Discoverer Administration Edition:

    • Creating a private end user layer for a new tutorial database user
    • Connecting to discoverer administrator, using the load wizard and the work area
    • Modifying the Business Area
    • Working with Custom Folders
    • Creating Joins
    • Customizing Items
    • Designing a complex Folder
    • Working with Hierarchies

    Form Development Process:

    • Template Form Architecture
    • Apps stand Architecture
    • FNDMENU Architecture
    • Coding Standards
    • Name Conventions
    • Form Development Process
    • WHO Information Tracking
    • Row LOV
    • Queries find Window
    • Customization of Forms
    • Programming of Non-Form Functions
    • Calendars

    Flexfields:

    • Introduction to Key and Descriptive Flexfields
    • Enabling a DFF
    • DFF Registration
    • KFF Registration
    • Define a KFF Flexfields Structure
    • Invoking DFF form of New Form
    • Invoking KFF Form of New Form

    Report Development:

    • Report Coding Standards
    • User Exits in Report design
    • Customization of Reports – Adding Parameters
    • Customization of Reports – Adding Logos

    Discoverer User Edition:

    • Creation of Simple Workbook
    • To design parameterized workbook
    • To change Heading items
    • To insert new sheet in the Workbook
    • To add and remove items from Workbook
    • To create duplicate sheet in Workbook
    • To add title to the Worksheet
    • To insert date, time, page numbers and image on
    • Header/Title of Workbook
    • To apply Conditional Formatting





  • Dinesh J
    CEO, Greens Technology
    Trainer, Exp: 12 yrs
    Mobile: +91 8939915577
  • Corporate training given to following
    companies.

  • My students are working with