Oracle E-Business Suite (R12.1.3) Technical RICEW
What you'll learn
- Oracle E-Business Suite Technical Components
- Reports, Interfaces, Conversions, Extensions, Workflows
- AOL Foundation Module
- Migration of AOL Components
- Oracle E-Business Version History
- AIM Methodology Docs
- Source Code For All The Sessiosn
Requirements
- SQL/PLSQL is Preferred, but not mandatory
Description
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
Who this course is for:
- Beginner in IT Domain
Instructor
10 + Years of IT Experience in Oracle E-Business Suite and Oracle ERP Cloud
5+ Years of IT Training Experience in SQL, PLSQL, Oracle E-Business Technical RIECW+OAF
Extensive Knowledge on RICEWF+OAF Components.
Hands on exposure to FBDI, ADF-DI, SOAP/REST WebServices in Oracle ERP Cloud
Knowledge on Fin-GL,FA, PPM-Projects, Contracts, Procurement etc modules
Having working on different projects like Implementation, Support , Upgrade and Rollout