Introduction to Oracle Applications
Role of Technical Consultant
Architecture
• Architecture of Oracle Application Package – Single Node
• Architecture of Oracle Application Package – Multiple Node
• 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
• Roe 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