ORACLE APPS TECHNICAL COURSE CONTENT

Table of Content

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 Parameter s

Flexfield Report with Single Structure

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

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 Hier archies

Form Development Process:

Template Form Architecture

Appsstand 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

Calendar s

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 Standar ds

User Exits in Report design

Customization of Reports – Adding Parameter s

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 For matting

Contact Us

We are always here to guide you...

Quick Enquiry

Please enter name.
Please enter name.
Please enter valid email adress.
Please enter Course name.
Please enter your comment.

sitcomputerairoli@gmail.com

+91 9619 3417 13

+91 7506 4114 34

Website : www.sitcomputer.in

We Are Social