OracleAppsTechnical R12 Training(Beginner to Expert)

OracleAppsTechnical R12 Training(Beginner to Expert), available at $59.99, has an average rating of 4.5, with 82 lectures, based on 417 reviews, and has 2534 subscribers.

You will learn about Oracle Applications Technical (EBS) RICEW Components Development and Customization Finance Technical (P-P Cycle) SCM Technical (O-C Cycle) This course is ideal for individuals who are Beginners to Advanced in Oracle Applications Technical (EBS) It is particularly useful for Beginners to Advanced in Oracle Applications Technical (EBS).

Enroll now: OracleAppsTechnical R12 Training(Beginner to Expert)

Summary

Title: OracleAppsTechnical R12 Training(Beginner to Expert)

Price: $59.99

Average Rating: 4.5

Number of Lectures: 82

Number of Published Lectures: 82

Number of Curriculum Items: 82

Number of Published Curriculum Objects: 82

Original Price: ₹4,999

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Beginners to Advanced in Oracle Applications Technical (EBS)

Target Audiences

Beginners to Advanced in Oracle Applications Technical (EBS)

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.

Course Curriculum

Chapter 1: About ERP and Different types of ERP's and Architecture & Roles & Documentation

Lecture 1: Technical Demo Session (Practical)

Lecture 2: What is ERP ? What are Different types of ERP Applications we have ?

Lecture 3: What is Oracle Applications ERP ? Roles and Responsibilities we have?

Lecture 4: What are the Different types of Projects we have in Oracle Applications

Lecture 5: Oracle Applications ERP Versions

Chapter 2: AOL (Application Object Library) & Report Registration

Lecture 1: What is AOL? Purpose of AOL ?

Lecture 2: How to Create User in Oracle Applications

Lecture 3: Different Types of Executables in Oracle Applications

Lecture 4: How to Register reports in Oracle Applications

Lecture 5: How to register reports with Parameters

Lecture 6: Report Registration with Parameters with Examples (Date)

Lecture 7: Types of Default Types

Lecture 8: Types of Value sets Part – 1

Lecture 9: Types of Value sets Part – 2

Chapter 3: Registration of Procedures , SQL * Plus & SQl loader as Concurrent Program

Lecture 1: PL/SQL programs registration

Lecture 2: PL/SQL Program with parameters

Lecture 3: SQL * Plus Registration

Lecture 4: SQL Loader Registration

Lecture 5: SQL Loader Developmemt

Chapter 4: P-P Cycle (Procure To Pay Cycle)

Lecture 1: How to Create Suppliers, Buyer, Items Creation and Tables and Joins

Lecture 2: Purchasing Business Flow & Requisition Document

Lecture 3: RFQ,Quotation Creation

Lecture 4: Purchase Order Creation and Table and Joins

Lecture 5: Receipt Creation and Tables

Lecture 6: Account Payables Business Flow – Invoice Types

Lecture 7: Account Payables – Invoice Creation and Transfer to GL

Lecture 8: Account Payables – Invoice Accounts Tables and Link To GL

Lecture 9: Account Payables – Payments Creation and Transfer to GL

Lecture 10: PO Receipt Invoice Query Creation

Lecture 11: PO Real time report Development-1

Lecture 12: PO Real time report Development-2

Chapter 5: O-C Cycle (Order To Cash Cycle)

Lecture 1: Order To cash Business Flow Theory

Lecture 2: Create Customer and Tables

Lecture 3: Create Sales Item and Tables

Lecture 4: Sales Order Creation and Flow with Tables – 1

Lecture 5: Accounts Business Flow execution

Chapter 6: Oracle Applications Features (Profiles , Flexfields, Multiorg)

Lecture 1: What is Profile ? Types of Profiles ? How to use profiles in front end?

Lecture 2: Access Profiles from BackEnd (Reports)

Lecture 3: Access Profiles from BackEnd (Procedures)

Lecture 4: What is Flexfields ? Types of Flexfields ? DFF Customization

Lecture 5: DFF Context Field Configuration

Lecture 6: About Key Flex Fields ? KFF Customization

Lecture 7: KFF Customization and Database Tables

Chapter 7: Multiorg Setup both Functional and Technical

Lecture 1: What is Multiorg ? What are the Organizations we have in Multiorg

Lecture 2: How to Configure Multi org from Applications

Lecture 3: Multiorg Structure (MOAC)

Lecture 4: Multiorg Org Practical Example with Operating Unit and New Employee

Lecture 5: Multiorg Org Practical Example with Ledger and New Employee

Lecture 6: Multiorg Structure (MOAC) Technical (Reports)

Lecture 7: Multiorg Structure (MOAC) Technical (SQL)

Chapter 8: Interfaces & Conversions and Execution

Lecture 1: Development of Outbound Interface

Lecture 2: Development of Items Outbound Interface

Lecture 3: Development of Inbound Interface (GL Journals Interface Development) Process

Lecture 4: Interface Validations – Theory

Lecture 5: GL Journals Interface Execution -1

Lecture 6: GL Journals Interface Execution -2

Lecture 7: PO Interface Process and Development

Lecture 8: PO Interface Development and Execution

Lecture 9: Difference between Interface and Conversions

Lecture 10: Oracle Applications (EBS) Interface Doubts

Lecture 11: Oracle Applications (EBS) Supplier Conversion Part -1

Chapter 9: Form Personalization & Forms Development

Lecture 1: Forms Personalization – Hide fields,Setting Properties dynamically

Lecture 2: Forms Personalization – Adding Menu options(SPECIAL Trigger)

Lecture 3: Forms Personalization – Adding Menu options( PL/SQL Code Execution)

Chapter 10: Oracle Applications XML and BI Publisher Templete Development and Customization

Lecture 1: XML Publisher Introduction and Manual Development

Lecture 2: XML Publisher Deployment in Oracle Applications R12

Lecture 3: XML Publisher Formula Columns

Lecture 4: XML Publisher With Parmameters

Lecture 5: XML Master detail Report

Lecture 6: XML Lexical Parameters -1

Lecture 7: XML Lexical Parameters -2

Lecture 8: XML Master detail report Manual development

Lecture 9: XML PL/SQL Data source development templete

Chapter 11: Interview Preparation

Lecture 1: AOL Interview Questions

Lecture 2: P-P and O-C Cycle Interview Questions

Lecture 3: Profiles , Flex fields Multiorg Interview Questions

Lecture 4: Interfaces Interview Questions and Answers

Lecture 5: GL Interfaces Interview Questions and Answers

Lecture 6: Form personalization Interview Questions

Lecture 7: What are Alerts in Oracle Applications

Lecture 8: What are the Basic Linux Commands we use Regular in oracle EBS Projects

Lecture 9: AIM Methodology in Oracle EBS Projects

Instructors

Chandra Mohan
Oracle Cloud ERP Instructor(Solution Architect&FreeLancer)

Rating Distribution

1 stars: 2 votes
2 stars: 7 votes
3 stars: 33 votes
4 stars: 160 votes
5 stars: 215 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu