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