Oracleappstechnical R12 Training(Beginner To Expert)

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

What you'll learn

Oracle Applications Technical (EBS)

RICEW Components Development and Customization

Finance Technical (P-P Cycle)

SCM Technical (O-C Cycle)

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 TechnicalRICEW-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 purchasingReporting Tools· Oracle XML Publisher/BI Publisher/ Data Definition Template · D2k Reports(RDF Reports)· SQL Reports· PLSQL ReportsOracle applications Alerts, Multi Org, MOAC,TCA Architecture,11i vs R12 Differences.AOL(Application Object Library)· Application Developer· System AdministratorAIM & OUM documentationOracle Workflow and Approval Management Engine(AME)Unix Shell ScriptingInterfaces And conversions program development.Inbound interface validations and loadingOutbound Extract integration with legacy systems.Oracle Forms Personalization's TopicsWhat is Form Personalization and why we required. changing LOVcalling procedureSetting initial ValueDisplay AOL MessagesHiding the fieldsRestricting line level qty with exampleForm personalization tables and migration from one instance to other instanceUnix Shell ScriptingSteps to Register Shell Script as a concurrent programUnix Script copying file from one location to other locationloading data by using unix scriptsubmitting concurrent program from unixBasic unix commandsSql Report DevelopmentPlsql Report DevelopmentPLSQL Report to EXCELDeveloper ReportsReport Development steps and report registrationDeveloper 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 toolconfine mode, flex mode, Align objects, size objects, send it to backdisplay limited records per pagedisplay amt in wordseach master records starts on the starting of the pagereset page numbering.Formula column with exampleSummary column with exampleplaceholder column with exampleFormat triggersDisplay dynamic imagescondtional formatting:dynamically hiding the fields.adding void reason to void payment register reportDisplay multiple values in single stringUser exitslexical parameter with formatted query exampleMatrxi report - outstanding sales order list including complete invoice historyCreation of table dynamicallyInclude zero invoice amounts.Report triggersDisplay dynamic report name in the outputDisplay dynamic company name in the report outputset rdf report with warning statuscalling a report from other reportcalling a report using form personalization.

Overview

Section 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

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

Lecture 6 What is AOL? Purpose of AOL ?

Lecture 7 How to Create User in Oracle Applications

Lecture 8 Different Types of Executables in Oracle Applications

Lecture 9 How to Register reports in Oracle Applications

Lecture 10 How to register reports with Parameters

Lecture 11 Report Registration with Parameters with Examples (Date)

Lecture 12 Types of Default Types

Lecture 13 Types of Value sets Part - 1

Lecture 14 Types of Value sets Part - 2

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

Lecture 15 PL/SQL programs registration

Lecture 16 PL/SQL Program with parameters

Lecture 17 SQL * Plus Registration

Lecture 18 SQL Loader Registration

Lecture 19 SQL Loader Developmemt

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

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

Lecture 21 Purchasing Business Flow & Requisition Document

Lecture 22 RFQ,Quotation Creation

Lecture 23 Purchase Order Creation and Table and Joins

Lecture 24 Receipt Creation and Tables

Lecture 25 Account Payables Business Flow - Invoice Types

Lecture 26 Account Payables - Invoice Creation and Transfer to GL

Lecture 27 Account Payables - Invoice Accounts Tables and Link To GL

Lecture 28 Account Payables - Payments Creation and Transfer to GL

Lecture 29 PO Receipt Invoice Query Creation

Lecture 30 PO Real time report Development-1

Lecture 31 PO Real time report Development-2

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

Lecture 32 Order To cash Business Flow Theory

Lecture 33 Create Customer and Tables

Lecture 34 Create Sales Item and Tables

Lecture 35 Sales Order Creation and Flow with Tables - 1

Lecture 36 Accounts Business Flow execution

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

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

Lecture 38 Access Profiles from BackEnd (Reports)

Lecture 39 Access Profiles from BackEnd (Procedures)

Lecture 40 What is Flexfields ? Types of Flexfields ? DFF Customization

Lecture 41 DFF Context Field Configuration

Lecture 42 About Key Flex Fields ? KFF Customization

Lecture 43 KFF Customization and Database Tables

Section 7: Multiorg Setup both Functional and Technical

Lecture 44 What is Multiorg ? What are the Organizations we have in Multiorg

Lecture 45 How to Configure Multi org from Applications

Lecture 46 Multiorg Structure (MOAC)

Lecture 47 Multiorg Org Practical Example with Operating Unit and New Employee

Lecture 48 Multiorg Org Practical Example with Ledger and New Employee

Lecture 49 Multiorg Structure (MOAC) Technical (Reports)

Lecture 50 Multiorg Structure (MOAC) Technical (SQL)

Section 8: Interfaces & Conversions and Execution

Lecture 51 Development of Outbound Interface

Lecture 52 Development of Items Outbound Interface

Lecture 53 Development of Inbound Interface (GL Journals Interface Development) Process

Lecture 54 Interface Validations - Theory

Lecture 55 GL Journals Interface Execution -1

Lecture 56 GL Journals Interface Execution -2

Lecture 57 PO Interface Process and Development

Lecture 58 PO Interface Development and Execution

Lecture 59 Difference between Interface and Conversions

Lecture 60 Oracle Applications (EBS) Interface Doubts

Lecture 61 Oracle Applications (EBS) Supplier Conversion Part -1

Section 9: Form Personalization & Forms Development

Lecture 62 Forms Personalization - Hide fields,Setting Properties dynamically

Lecture 63 Forms Personalization - Adding Menu options(SPECIAL Trigger)

Lecture 64 Forms Personalization - Adding Menu options( PL/SQL Code Execution)

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

Lecture 65 XML Publisher Introduction and Manual Development

Lecture 66 XML Publisher Deployment in Oracle Applications R12

Lecture 67 XML Publisher Formula Columns

Lecture 68 XML Publisher With Parmameters

Lecture 69 XML Master detail Report

Lecture 70 XML Lexical Parameters -1

Lecture 71 XML Lexical Parameters -2

Lecture 72 XML Master detail report Manual development

Lecture 73 XML PL/SQL Data source development templete

Section 11: Interview Preparation

Lecture 74 AOL Interview Questions

Lecture 75 P-P and O-C Cycle Interview Questions

Lecture 76 Profiles , Flex fields Multiorg Interview Questions

Lecture 77 Interfaces Interview Questions and Answers

Lecture 78 GL Interfaces Interview Questions and Answers

Lecture 79 Form personalization Interview Questions

Beginners to Advanced in Oracle Applications Technical (EBS)