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.
Beginners to Advanced in Oracle Applications Technical (EBS)


Homepage:

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