Oracle Apps Technical R12 Training(Beginner to Expert)

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 andFor 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 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 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.