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