Oracle Apps DBA Training in Bangalore

Introduction to Oracle Applications

• 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

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 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

Perl/Tk

• Creating a Perl/Tk Application
• GUI Programming Overview
• Adding Widgets
• Scrolled Widgets
• Configuring Widgets
• Menus
• More Fun with Menus
• Using FileSelect

Perl/Tk Programming

• Tk::Error and Tk::ErrorDialog
• Configuring Widgets
• Geometry Management
• Geometry Management with grid()
• The Frame Widget
• Defining Widget Callbacks
• Bindings
• Nonblocking I/O with fileevent()
• Tags
• Other Widgets
• Other Tk Commands
• Getting Tk
• Extending Perl with C/C++
• Extending the Perl Interpreter
• Overview of Perl5 XSUBs
• Get Started with h2xs
• Set up the Perl Wrapper Class
• Write the XS Code
• The XS File
• Write Some Test Code
• What Do You Want?
• Returning Values on the Stack
• A Walk Through an XSUB
• Arguments to XSUBs
• Other h2xs Options
• Embedding the Perl Interpreter
• Why Embed Perl?
• Embedding Perl in a C Program
• Compiling the Prog