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
-
