OracleAppsTechnical R12 Training(Beginner to Expert)

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.