ORACLE APPS TECHNICAL

Introduction to ERP

Definition of ERP, Overview of popular ERP’S

Comparison of Oracle Apps with other ERP’S

Types of Roles

Types of Projects

AIM documentation standards

Oracle Application Architecture.

Database structure of OA

Using TOAD

 

Application Object Library

Creating Users

WHO columns

Creating Responsibilities

Request group construction

 

Application development

Defining concurrent program

Concurrent programs with parameters

Working with multiple concurrent programs

Scheduling the Concurrent Program

Concurrent Program incompatibilities

Creating Request Set

Procedure registration

Value sets

 

Value sets

Overview of value sets

Options in value sets

Types of value sets

Creation of value set

Overview of value set tables

 

Registration of Custom Objects

Registration of Application

Report development

Report registration

Parametric report registration

Registration of a Table

Registration of Sql, Sql Loader, PL/SQL programs

 

– Report Development:

– Customization of Reports – Adding DFF Info

– Customization of Reports – Removing Parameters

– Flexfields Report with Single Structure

– Report Coding Standards

– User Exits in Report design

– Customization of Reports – Adding Parameters

– Customization of Reports – Adding Logos

 

Discoverer Administration Edition:

– Creating a 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

– Customizing Items

– Designing a complex Folder

 

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

 

Interfaces

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.

 

Conversions

Overview on conversions

Difference between Interfaces and conversions

Working with staging table script

Developing validations package

Standards to be followed in conversions

 

Flex Fields

Overview of flex fields

Types of Flex Fields

Descriptive Flex Fields

Key Flex Fields

Step in creation of DFF

Flex fields tables and relations

 

Profiles

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

 

Multi Org Concepts

What is Multi Org and why we need.

Multi Org Tables.

Multi Org Views.

 

PO Overview and tables

Overview of purchasing

Major setups and transactions

Overview of some purchasing tables

 

 

INV Overview and Tables

    Footer Sidebar 7
    Curabitur quis tempus ipsum. Vivamus tincidunt sollicitudin facilisis. Phasellus elementum tortor eu magna tincidunt lacinia. Nullam ac nulla vel enim molestie luctus. In et tempus purus, ac tempor metus. Vestibulum quis semper lorem, sed tempus turpis. Cras lobortis erat ipsum, sed venenatis lacus blandit eget. Mauris sed pharetra felis, ut fringilla odio. Phasellus vitae libero ut lectus sagittis porttitor.

    Etiam magna arcu, ullamcorper ut pulvinar et, ornare sit amet ligula. Aliquam vitae bibendum lorem. Cras id dui lectus. Pellentesque nec felis tristique urna lacinia sollicitudin ac ac ex. Maecenas mattis faucibus condimentum. Curabitur imperdiet felis at est posuere bibendum. Sed quis nulla tellus.

    ADDRESS

    63739 street lorem ipsum City, Country

    PHONE

    +12 (0) 345 678 9

    EMAIL

    info@company.com

    Cart
    Quick Enquiry
    Thank You. We will contact you as soon as possible.