ORACLE Apps Technical (R12)
This presentation is the property of its rightful owner.
Sponsored Links
1 / 4

Oracle Apps Technical Training in Hyderabad. PowerPoint PPT Presentation

Best institute for APPS training in Hyderabad.we are providing a quality serves and real time guidance, with real time projects and 24/7 facility.

Download Presentation

Oracle Apps Technical Training in Hyderabad.

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Oracle apps technical training in hyderabad

ORACLE Apps Technical (R12)

course content

Introduction to ERP

Definition of ERP, Overview of popular ERP'S.

Comparison of Oracle Apps with other ERP'S.

Over view of Oracle E-Business suite ( EBS).

Oracle Application Architecture.

Oracle apps product families .

Database structure & Application Structure of OA.

RICE & CEMLI components.

Different types of Projects.

Application Object Library ( AOL )

Creating Users.

WHO columns.

Creating Responsibilities.

Menu construction.

Request group construction.

Multi organization structure.

Application Implementation Methodology(AIM).

Application Development

Defining concurrent program.

Concurrent programs with parameters.

Creation of Executables(oracle reports, PL/SQL Stored Procedures,

Host, SQL * Loader)

Scheduling the Concurrent Program.

Concurrent Program Incompatibilities.

Creating Request Set.

Creation of Value sets.

Creation of None , Independent , Table , Dependent , Special and Pair Value sets.

Usage of $FLEX$ in value sets.

Usage of $Profiles$ in Value Sets.

Lookup Types in Apps and Usage in Queries.

Overview of Profile Options.

Different Levels of Setting Profiles.

Understanding Multi Org Access Control ( MOAC).

Oracle apps technical training in hyderabad

ORACLE Apps Technical (R12)

course content

Overview of Tables and their relations.

Table Naming conventions in Oracle Apps.

Finding out Table names form Forms & OAF pages.

Understand eTRMs and Table Relations.

PO Tables Overview.

AP Tables Overview.

GL Tables Overview.

AR Tables Overview.

OM Tables Overview.

INV Tables Overview.

HZ Tables Overview.

Difference between 11i and R12 tables.


Report Registration.

Form registration.

PL/Sql Program Registration.

XML/BI Publisher Report Registration.

SQL * Loader Program and UTL_FILE program.

Interfaces & Conversions

Introduction to Interfaces .

Development Process of Interface.

Develop Inbound Interface programs (Using SQL * Loader).

Develop Outbound Interface programs (Using UTL_FILE).

Overview on conversions.

Difference between Interfaces and conversions.

Working with staging table script.

Developing validations package.

Standard Import Program execution.

Standards to be followed in conversions.

Working with Public APIs.

Flex Fields

Over view of Flex Fields.

Descriptive Flex Fields.

Key Flex Fields.

Difference Between KFF and DFF.

Oracle apps technical training in hyderabad

ORACLE Apps Technical (R12)

course content

Module Overviews

Procure to Pay (P2P) process flow with base tables .

Order to Cash (O2C) process flow with base tables.

AP module Overview and Flow with Base Tables.

AR Module Overview and Flow with Base Tables.

PO Module Overview and Flow with Base Tables.

GL Module Overview and Flow with Base Tables.

OM Module Overview and Flow with Base Tables.

TCA Architecture overview and Tables.

XML/BI Publisher

Introduction to XML Publisher.

Difference between D2K Reports and XMLP Reports.

Development of XML/BI Publisher thru D2K Reports.

Development of XML/BI Publisher thru PL/SQL.

Development of XML/BI Publisher thru Data Template.

Creating Data Definitions.

Creating Templates.

Working with xml loops and xml tags.

Tabular, Master-Detail and Matrix XML/BI Reports development.

Development of Multi Layout XML/BI Publisher report.

XML/BI Conditional formatting and Layout features.

XML Bursting.


Introduction to workflow.

Understanding about Workflow Components.

Overview of Workflow Builder.

Creation of workflow Builder components Item Type, Process, Notification , Message

, Attribute , Lookup types and Functions.

Development of workflow with about workflow components.

Creating Workflow Functions with Multiple return values.

Creating Sub Process.

Workflow APIs and Workflow Tables.

Opening URLs from Notification.

Calling Oracle Apps pages from Notifications.

Oracle apps technical training in hyderabad

ORACLE Apps Technical (R12)

course content

Providing Dropdown List in the Notification.

Creating Text input field in the Notification.

Displaying From Role In Notifications.

Writing HTML code in Notifications.

Attaching Documents to Notifications.

Ad-role Creation.

Workflow Access Roles.

Workflow Definition Loader Program.

Execution of one end to end Workflow with above options.


Introduction to discoverer tool.

Discoverer Administration Edition.

Discoverer Desktop Edition.

Creation of End User Layer (EUL ).

Creating Business Areas.

Creation of workbooks.

Development of objects with real time requirements

Technical design document preparation.

Development of XMLP/BI Real Time Report.

Development of Real time Interface / Conversion.

Real time Workflow Explanation.

Providing FAQs (700+ ) Interview Questions Document.

Oracle 11g ( SQL , PL/SQL ) Free with Apps technical

D2K 10g ( Forms & Reports ) Free with Apps technical

  • Login