Application System Administrations and AOL

• Introduction
• Understanding Online and Concurrent Processing in 11i
• Define applicants User and assign the Responsibility Oracle users vs AOL Users
• Understanding the Responsibility and its structure
• Introduction to AOL
• Understanding the Responsibility and its structure
• Define and Customizing the Responsibility, Menus,
  Request, Groups Data Groups and request set
• AD-DD Package to register tables, views and sequences  
• Register a custom form for an Standard Applications.
• Register a custom report, DB Procedure for an standard Applications as a concurrent Program.
• Define a Concurrent Program for SQL Script and Shell Script.

New Custom Form Development

• Understanding the TEMPLATE and APPSTAND forms Architecture.
• Understanding and using the TEMPLATE Triggers.
• Understanding the following the forms Coding Standards.
• Using the CUSTOM.Pll Library, using seeded, libraries.
• Non-form function, Query form window.
• Zoom function, Application Messages.

New Report Development

• Understanding and following the Reports Coding Standards.
• Define User Exists in Report Triggers.
• Writing report to display the flexfield Data.
• Multi org and currency format in reports.
  

New Custom Module Development

• Understanding a Custom What? Why? How?
• Steps to setup a custom application.
• Customizing seeded forms and reports and integrating with custom module.

Customizing Seede Components

• Reports
• Forms
• Workflows

Flexfields

• Understanding the flexfields
• Introduction to types of flexfields: KFF and DFF
• Registering a KFF
• Registering a DFF
• Defining a DFF on custom form

Applications 11i Interfaces

• Converting legally data into Oracle application database.
• Integrating non-11i Systems with 11i systems.
• Writing feeder program.
• Working with SQL loader UTL file page and in-bound and out-bounded interfaces.
• Developing custom interfaces.

Oracle Alerts

• Up-gradation
• Understanding the Migration/Up-gradation of Oracle e-business Suite 11i,10.7/11.0 to 11i.
• Up-gradation forms 4.5 to forms 6i.

Oracle Workflow

• WF concepts
• WF Architecture
• WF Setup & Configuration
• Working with WF Builder and WF loader.
• Designing WF process diagram.
• Writing PL/SQL procedure of WFs.
• Monitoring and troubleshooting workflow activities.

Oracle Discovers

• Discover 4i vs Oracle reports 6i
• Discover architecture
• Creating Discover EUL
• Defining Business Areas
• Discoverer in Apps reports
• Creating Discoverer reports