OracleAppsTechnical R12 Training(Beginner to Expert) - Udemy

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)


Homepage

https://www.udemy.com/course/oracle-applications-technical-coursebeginner-experienced/