Course Introduction

This course of study introduces students to the techniques and tools required to develop database driven web applications. The course teaches students how to design, develop, and deploy beautiful, responsive, database-driven web applications using Oracle.

Course Syllabus:

Architecture

  •  Architecture of Oracle Application Package
  •   Product Directory StructuresUsers
  •   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

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

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

Flexfields

Report Development

  •     Report Coding Standards
  •     User Exits in Report design
  •     of Reports – Adding Parameters
  •     Customization of Reports – Adding Logos

 

 

 

 

 

 

 

 

 

 

Leave A Message

There are no any courses offered by this institute...!