Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

OracleAppsTechnical R12 Training(Beginner to Expert)

Name: OracleAppsTechnical R12 Training(Beginner to Expert)
Rating: 4.5 (893 reviews)

Oracle Apps Techno Functional Course (Expert Level) (2021) Latest Version

Created byChandra Mohan

Last updated 2/2026

English

Arabic [Auto],English [Auto],

What you'll learn

Oracle Applications Technical (EBS)
RICEW Components Development and Customization
Finance Technical (P-P Cycle)
SCM Technical (O-C Cycle)

Course content

11 sections • 91 lectures • 35h 46m total length

Technical Demo Session (Practical)44:30
What is ERP ? What are Different types of ERP Applications we have ?8:03
Define enterprise resource planning and explore major ERP types, with emphasis on Oracle applications such as e-business suite and its integrated financial, HR, CRM, and supply chain data.
What is Oracle Applications ERP ? Roles and Responsibilities we have?17:42
Discover Oracle Applications ERP modules like financials, supply chain management, human capital management, customer relationship management, and procurement, and learn the roles of DBAs, functional consultants, and technical consultants.
What are the Different types of Projects we have in Oracle Applications8:16
Oracle Applications ERP Versions8:14

What is AOL? Purpose of AOL ?9:37
How to Create User in Oracle Applications43:23
Learn to create a user in Oracle Applications, assign system administrator and application developer responsibilities, set effective dates, and audit who created records and who connected to the application.
Different Types of Executables in Oracle Applications6:12
How to Register reports in Oracle Applications41:23
Hi ,

In this lession you are going to learn how to register report in Oracle Applications.
How to register reports with Parameters30:32
Hi ,

In this lession you are going to learn how to register report with parameters in Oracle Applications.
Report Registration with Parameters with Examples (Date)25:38
Types of Default Types25:08
Types of Value sets Part - 129:41
Types of Value sets Part - 226:15

How to Create Suppliers, Buyer, Items Creation and Tables and Joins37:59
Explore how to create suppliers, items, and buyers in Oracle apps, and use tables and joins to manage inventory data, supplier contacts, and procurement workflows.
Purchasing Business Flow & Requisition Document33:57
RFQ,Quotation Creation20:35
Purchase Order Creation and Table and Joins21:51
Receipt Creation and Tables40:56
Explore blanket purchase and contract agreements, create and release blanket orders, and master receipt creation, three-way matching, and invoice and inventory integration in Oracle Apps R12.
Account Payables Business Flow - Invoice Types9:04
Explore the account payables flow by detailing invoice types such as standard invoice, prepayment, credit memo, debit memo, withholding tax, recurring invoices, expense reports, interest invoices, miscellaneous, transportation, and retainer.
Account Payables - Invoice Creation and Transfer to GL25:26
Account Payables - Invoice Accounts Tables and Link To GL18:43
Explore how invoices flow from accounts payable to the general ledger, including header and line accounting, subledger accounting links, data transfer, and validation.
Account Payables - Payments Creation and Transfer to GL27:02
PO Receipt Invoice Query Creation21:49
PO Real time report Development-144:30
PO Real time report Development-250:41
Develop a real-time PO report by wiring four queries, creating data links, and building repeating frames for header, lines, shipments, and distributions.

Order To cash Business Flow Theory33:53
Create Customer and Tables19:27
Create Sales Item and Tables23:07
Create a standard sale item, configure it as an inventory, purchasing, and sales item, assign to organizations, and increase quantity via purchases and miscellaneous transactions to support order-to-cash invoicing.
Sales Order Creation and Flow with Tables - 126:42
Accounts Business Flow execution19:18

What is Profile ? Types of Profiles ? How to use profiles in front end?36:04
How to Access profiles from Value set (:$PROFILES$) Example25:16
How to Configure Dependency in Table Value set (:$FLEX$) Example14:00
Access Profiles from BackEnd (Reports)27:56
Access profile values from the backend in reports and display the current user and responsibility. Configure profile usage and placeholders for user-based filtering.
Access Profiles from BackEnd (Procedures)24:04
What is Flexfields ? Types of Flexfields ? DFF Customization16:37
Explore Oracle apps flexfields, including descriptive and key flexfields, and learn to customize forms by adding fields through descriptive flexfields, mapping to tables, and unfreezing segments.
DFF Context Field Configuration16:48
About Key Flex Fields ? KFF Customization10:51
Explore key flex fields and their customization in Oracle apps, explaining how code and description capture important information securely, and how context and segment columns support financial and item data.
KFF Customization and Database Tables19:09

What is Multiorg ? What are the Organizations we have in Multiorg16:15
How to Configure Multi org from Applications24:03
Learn to configure multi org in Oracle Apps by creating business groups, operating units, ledgers, and legal entities. Assign these structures to users via profiles and security profiles.
Multiorg Structure (MOAC)26:35
Explore multiorg structure in Oracle Apps R12, including how security profiles, responsibilities, and operating units enable cross-unit access via multi org view constructs.
Multiorg Org Practical Example with Operating Unit and New Employee33:39
Learn how to hire an employee, assign operating units and organizations via profiles, create and attach a purchasing responsibility, and test access across operating units and security profiles.
Multiorg Org Practical Example with Ledger and New Employee9:52
Multiorg Structure (MOAC) Technical (Reports)16:26
Multiorg Structure (MOAC) Technical (SQL)15:55

Development of Outbound Interface23:26
Development of Items Outbound Interface19:36
Explore developing an items outbound interface in Oracle Applications Technical R12, extracting item data from the database using parameters and writing it to a file with exception handling.
Development of Inbound Interface (GL Journals Interface Development) Process13:32
Learn to build an inbound interface for Oracle applications, specifically GL journals, by processing client flat files into staging tables, validating data, and loading into interface and base tables.
Interface Validations - Theory11:46
GL Journals Interface Execution -117:09
GL Journals Interface Execution -248:07
Learn to load and validate flat-file data into Oracle General Ledger interfaces, using staging and interface tables, with debit/credit checks, currency validations, and journal import processes.
Oracle Apps Technical Journals Import Interface Errors Handling20:48
PO Interface Process and Development29:31
Develop and validate a purchase order interface in Oracle Applications by loading header, line, shipment, and distribution data through staging and interface tables, with standard programs and validations.
PO Interface Development and Execution46:12
Difference between Interface and Conversions18:47
Oracle Applications (EBS) Interface Doubts7:26
Oracle Applications (EBS) Supplier Conversion Part -122:59

XML Publisher Introduction and Manual Development28:23
Learn how ExxonMobil publisher integrates data logic, layout, and translation with templates to publish multilingual reports from a single data source in formats like Word, PDF, and Excel.
XML Publisher Deployment in Oracle Applications R1219:17
Register and deploy a report as a concurrent program in Oracle applications, upload the report, attach the data definition and template, configure output layout, and assign to a request group.
XML Publisher Formula Columns30:51
XML Publisher With Parmameters12:03
XML Master detail Report9:36
XML Lexical Parameters -115:39
XML Lexical Parameters -218:03
XML Master detail report Manual development25:58
Learn manual development of an XML master-detail report using Oracle Apps R12, guided by ExxonMobil publisher templates and documentation to build and render complex supplier reports.
XML PL/SQL Data source development templete40:05
Learn to build XML PL/SQL data source templates in Oracle Apps R12, extract data with select statements, define columns and segments, and create procedures to generate reports.
XML Data Defination Template Configuration45:25
XML Data Defination with Parameters and Logo Change49:33
Learn to build xml data definitions with parameters, register concurrent programs, and print parameterized reports using data templates and rtf, including logos, page breaks, and call templates.
XML with Sub Templates Configuration32:15
Learn to configure xml publisher sub templates in Oracle Apps R12 by using a main template that selects country-specific sub templates via if conditions to produce purchase order details.
XML Bursting Concept and Execution36:32
Master XML bursting concept to automatically mail concurrent program outputs by extracting the current running request id via fnd_global, configuring XML publisher, bursting data definitions, and using after report triggers.

Requirements

SQL and PL/SQL

Description

This Course is designed for working professionals and freshers who wants to enter into Oracle EBS Technical consultant role.

Will be suitable for freshers to learn right from the scratch .

For the people who are working in Oracle Apps Functional also can upgrade their skills into technical and become as Techno-Functional consultant and

For the people who are working as apps technical they can learn advanced topics and also more topics which are not available in the projects also covered.

Oracle Apps SCM And Finance and HRMS Technical

RICEW-Reports ,Interfaces,Conversions,Extensions,Workflow.

Business Cycles will be discussed:

· Procure To pay(P2P) (PO-AP-GL)

· Order to cash(O2C) (OM-AR-GL)

· HRMS CoreHR and Payroll Technical

· Oracle projects Billing and Costing flow and its integration with payables receivables inventory and purchasing

Reporting Tools

· Oracle XML Publisher/BI Publisher/ Data Definition Template

· D2k Reports(RDF Reports)

· SQL Reports

· PLSQL Reports

Oracle applications Alerts, Multi Org, MOAC,TCA Architecture,11i vs R12 Differences.

AOL(Application Object Library)

· Application Developer

· System Administrator

AIM & OUM documentation

Oracle Workflow and Approval Management Engine(AME)

Unix Shell Scripting

Interfaces And conversions program development.

Inbound interface validations and loading

Outbound Extract integration with legacy systems.

Oracle Forms Personalization's Topics

What is Form Personalization and why we required.

changing LOV

calling procedure

Setting initial Value

Display AOL Messages

Hiding the fields

Restricting line level qty with example

Form personalization tables and migration from one instance to other instance

Unix Shell Scripting

Steps to Register Shell Script as a concurrent program

Unix Script copying file from one location to other location

loading data by using unix script

submitting concurrent program from unix

Basic unix commands

Sql Report Development

Plsql Report Development

PLSQL Report to EXCEL

Developer Reports

Report Development steps and report registration

Developer reporting tool fundamentals like Bind parameter, Lexical parameter, Summary column, Formula column, Place holder column, Data link, Data model, layout model, Frame ,Repeating Frame, Text field ,Boiler Text ,OLE2, pinning a tool

confine mode, flex mode, Align objects, size objects, send it to back

display limited records per page

display amt in words

each master records starts on the starting of the page

reset page numbering.

Formula column with example

Summary column with example

placeholder column with example

Format triggers

Display dynamic images

condtional formatting:

dynamically hiding the fields.

adding void reason to void payment register report

Display multiple values in single string

User exits

lexical parameter with formatted query example

Matrxi report - outstanding sales order list including complete invoice history

Creation of table dynamically

Include zero invoice amounts.

Report triggers

Display dynamic report name in the output

Display dynamic company name in the report output

set rdf report with warning status

calling a report from other report

calling a report using form personalization.

Who this course is for:

Beginners to Advanced in Oracle Applications Technical (EBS)

OracleAppsTechnical R12 Training(Beginner to Expert)

What you'll learn

Explore related topics

Course content

About ERP and Different types of ERP's and Architecture & Roles & Documentation5 lectures • 1hr 27min

AOL (Application Object Library) & Report Registration9 lectures • 3hr 58min

Registration of Procedures , SQL * Plus & SQl loader as Concurrent Program5 lectures • 1hr 42min

P-P Cycle (Procure To Pay Cycle)12 lectures • 5hr 53min

O-C Cycle (Order To Cash Cycle)5 lectures • 2hr 2min

Oracle Applications Features (Profiles , Flexfields, Multiorg)9 lectures • 3hr 11min

Multiorg Setup both Functional and Technical7 lectures • 2hr 23min

Interfaces & Conversions and Execution12 lectures • 4hr 39min

Form Personalization & Forms Development5 lectures • 2hr 11min

Oracle Applications XML and BI Publisher Templete Development and Customization13 lectures • 6hr 4min

Requirements

Description

Who this course is for: