Oracle E-Business Suite (R12.1.3) Technical RICEW

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 (4)

  • Upgrade, Implementation, Support, Rollout

• AIM documentation standards (OUM Oracle Unified Method)

• Oracle Application Architecture.

• Database structure of OA

• Using TOAD/SQL Developer

• Latest 2030 Strategy of Oracle E-Business Suite

Application Object Library - FND – Foundation Module

• Creating Users

• WHO columns

• Creating Responsibilities

• Menu construction

• Request group construction

• Flexfield

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

Reports- RDF

• Hello World Report development

• Parametric report registration

• Reports with repeating frames

• Reports with Lexical Parameter, Placeholder Columns

• Reports with PLSQL Integration

• Invoking Report from PLSQL Program

• Modifying Standard Reports Process

XML Publisher

• Introduction to XML Publisher

• Creating Templates

• Creating Data Definitions

• XML Reports with Different Approaches (RDF/DataModel/PLSQL/OAF)

• Parameterized Reports

• Group Report

• Dynamic Columns Report

• Pivot Report

• XDO Functions – RowColor, IFCondition etc

Form registration

• Template.fmb

• Appstand.fmb

• Form development using templates

• Form customization concepts

• Form Registration Process

• Custom.Pll

• Using function Zoom_available( )

• Using procedure Event( )

Interfaces & Conversions

• Introduction to Interfaces and Conversions

• Inbound Interfaces

  • Supplier

  • GL Journal

  • Item Master

  • Purchase Order

  • AR Receipts

• SQLLoader

  • Process CSV File

  • Process Fixed Length

  • Upload to multiple tables

• UTL_FILE (read/write)

Deployment/Migration

• Unix Basics

• Migration Script for : Reports, Interfaces, Conversions, Forms, Workflow and AOL Components

• Workflow

  • FYI, FYA

  • Modifying Standard Workflow

  • Invoking via PLSQL