Oracle Apps Technical

ORACLE APPS TECHNICAL

Introduction to Oracle Applications

Role of Technical Consultant

Architecture

Architecture of Oracle Application

Package – Single Node

Architecture of Oracle Application

Package – Multiple Nodes

Product Directory Structure – Single

Node

Product Directory Structure – Multiple

Node

Users

Responsibilities

Role of APPS Database user

File objects in Oracle Applications

Database objects in Oracle

Applications

Multi Organization

Profile options

Front end Audit trial

Registration

Table Registration

Table Registration using Ad-dd

Package

View Registration

Sequence Registration

New Application / 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

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

Fiexfields

Introduction to Key and Descriptive

FIEXFIEDS

Enabling a DFF

Value sets

DFF Registration

KFF Registration

Define a Key FIEXFIELDS 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

Customization of Reports – Adding

DFF Info

Customization of Reports – Removing

Parameters

FIEZFIELD Report with Single

Structure

Interface Development

Interface Scenarios

Interface table design

Writing important programs

Coding PL/SQL concurrent program

Custom Interface import

Daily rates import

Sales tax rates import

Up gradation

Forms Up-gradation

Reports Up-gradation

Menus Up-gradation