Defining concurrent program

Concurrent programs with parameters

Working with multiple parallel programs

Scheduling the Concurrent Program

Concurrent Program incompatibilities

Creating a Request Set

Procedure registration

Overview of value sets

Options in value sets

Types of value sets

Creation of value set

Overview of value set tables

Registration of Application

Report development

Report registration

Parametric report registration

Registration of a Table

Registration of SQL, SQL Loader, PL/SQL programs

Customisation of Reports – Adding DFF Info

Customisation of Reports – Removing Parameters

Flexfields Report with Single Structure

Report Coding Standards

User Exits in Report design

Customisation of Reports – Adding Parameters

Customisation of Reports – Adding Logos

Creating an end user layer

database user

Connecting to discoverer administrator, using the load

wizard and the work area

Modifying the Business Area

Working with Custom Folders

Creating Joins

Customising Items

Designing a complex Folder

Creation of Simple Workbook

To develop parameterised workbook

To change Heading items

To insert new sheet in the Workbook

To add and remove items from Workbook

To create a duplicate sheet in Workbook

To add a title to the Worksheet

To insert date, time, page numbers and image on

Header/Title of Workbook

To apply Conditional Formatting

Introduction to Interfaces

Outbound Interfaces

Using UTL_FILE package

Inbound Interfaces

Using SQL * Loader tool / dynamic table for files read( New concept)

SQL * Loader Concepts

Data File.

Control File.

Bad File.

Discard File.

Log File.

Commands in SQL * Loader

Registration Of control File in Oracle Apps.

Overview of conversions

Difference between Interfaces and conversions

Working with staging table script

Developing validations package

Standards to be followed in conversions

Overview of flex fields

Types of Flex Fields

Descriptive Flex Fields

Key Flex Fields

Step in the creation of DFF

Flex fields tables and relations

Overview of profile options

Different levels in Setting profiles

Steps in setting a profile option

Some important profile options

Some important API’s of profiles

What is Multi-Org and why we need it?

Multi-Org Tables.

Multi-Org Views.

Overview of purchasing

Major setups and transactions

Overview of some purchasing tables

Overview of inventory

Major configurations and transactions

Overview of some INV Tables

Overview of order management

Major setups and transactions

Overview of some Order Management Tables

Overview of GL

Major installations and transactions

Overview of some GL tables

Overview of payables

Major setups and transactions

Overview of some payable tables

Overview of alerts

Types of alerts

Creation of alerts

Introduction to workflow

Workflow builder

Attributes

Creating Processes

Introduction to XML Publisher

Generating XML file using reports

Creating Templates

Creating Data Definitions