Thursday, 31 March 2016

Oracle Apps R12/11g Technical online training with Real time Server

SITC India providing professional Oracle Apps R12 Technical Training in Bangalore,Hyderabad location by experienced Oracle Technical consultants working in reputed companies / MNC’. Our training strategies are Class room training / Online live classes. Trainers are Experienced Oracle working professionals as technical consultant. Faculty will provide real time scenario along with practical hands on.

Individual training with one to one focus would be given along with focus on projectscenario, more focus provided on practical’s, examples, assignments etc. Our Oracle trained candidates are well posted in Projects for Companies like TCS, Wipro, Hexaware, Accenture, Price Waterhouse Coopers, Infosys and CTS.

Prerequisite: Oracle SQL, PL SQL, Reports and forms knowledge is must

ORACLE APPS Technical Course Content

Introduction to ERP

1. Definition of ERP
2. Overview of popular ERP’S
3. Comparison of Oracle Apps with other ERP’S
4. AIM documentation standards
5. Oracle Application Architecture.
6. Database structure of OA Using TOAD
7. Introduction to SQL and PL/SQL.

8. Application Object Library
System Administration and Application Object Library (AOL)
Defining an Applications User and Assigning the Responsibilities.
Understanding AOL and its Components
WHO columns
Creating Responsibilities
Request group creation
Menu Creation.

9. Application development 
Defining concurrent program
Concurrent programs with parameters
Working with multiple concurrent program
Concurrent Program incompatibilities
Creating Request Set
Default Types
1. Value sets.

10. Registration of Custom Objects
Report registration
Registration of a Table.

11. Interfaces and Conversions
Introduction to Interfaces
Difference Between Interfaces and Conversions
Outbound Interfaces
1. Using UTL_FILE package
Inbound Interfaces
1.Using SQL * Loader tool SQL * Loader Concepts o Data File.
2. Control File.
3. Bad File.
4. Discard File.
5. Log File.
Working with staging table script
Developing validations package
Standards to be followed in conversions
Using oracle API’s in Interfaces and Conversions
Interface Tables and Error Tables.

12. Flex Fields
Overview of flex fields
Types of Flex Fields
1. Descriptive Flex Fields
2. Key Flex Fields
Steps in creation of DFF
Flex fields tables and relations.

13. Profiles
Overview of profile options
Different levels in Setting profiles
Steps in setting a profile option
Some important profile options
Some important API’s of profiles.

14. Value sets
Overview of value sets
Options in value sets
Types of value sets
Creation of value set
Overview of value set tables
Usage of $FLEX and $PROFILE.

15. Multi Org Concepts
What is Multi Org and why we need.
Multi Org Tables.
Multi Org Views.

16. Functional Modules Overview
Overview of Procure to Pay Flow (P2P Cycle)
Overview of Order to Cash Flow (O2C Cycle)
Major setups and transactions
Overview of important tables in HRMS,PO,INV,OM,AP,AP,GL.

17. Reports in Oracle Applications
Introduction and Usage of USER_EXITS.
Developing a Report from scratch as per Client Requirement.
Developing a Report based on MD 50 Document.
Customization of Oracle Standard Reports.
Reports Registration Steps in Oracle Applications
Standards to develop a report in Oracle Apps.

18. Forms in Oracle Applications
New Form Development Process
Form Registration in Oracle Applications.
Calling one Form to another Form by using Button
Master-Detailed Forms
Form Personalization in Oracle Applications
Form Personalization v/s Form Customization.

19. Development of XML Publisher Reports.


At the end of session CV preparation, Interview questions, Placement Guidance will be provided. As SITC India is manpower sourcing company providing manpower fresher to experienced in Oracle and other technology across india we can support our students well for Placements in Reputed IT companies and MNC’s.