page header image

Oracle Apps Technical

About Course

The various applications in Oracle’s integrated application suite are arguably some of the most sought after apps in the world today. They are easy to use and help users achieve more than the best in terms of efficiency in work, thus increasing productivity for businesses that use them, leading to faster growth. The Oracle Apps Technical  training program seeks to provide students with knowledge and mastery of Oracle applications to help them clinch their dream jobs and add a feather to their cap. It will also bring them closer to becoming a certified Oracle Applications Technical Consultant.



                                                                 Oracle Apps Technical Course Content

1

Introduction To Oracle Applications Role of Technical Consultant

2

The 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

3

RegistrationTable,Registration,Table,Registrationusing,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

4

Report Development Customization of Reports –Adding DFF Info, Customization of Reports –Removing Parameters,FlexfieldReport with Single Structure

5

Interface Development Interface Scenarios,Usage of Standard Import Programs,Daily Rates Import,GL_Interface,Up-gradation,Forms Up-gradation,Reports Up-gradation,Menus Up-gradation

6

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

7

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

8

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

9

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

10

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 orksheet,To insert date, time, page numbers and image on Header/Title of Workbook
To apply Conditional Formatting

Coaching offers a way forward, so you can start transforming your life and turn your dreams into reality.