ORACLE APPS TECHNICAL COURSE CURRICULUM

Download [PDF]

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