Oracle Apps R12 Technical Training In Bangalore.

Basic Introduction

NI Anaytics India providing professional Oracle Apps R12 Technical Training in Bangalore locationby 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 NI Analytics 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.

For more information Demo class , Admission, New batches Please contact 9535024636 / 9916806516, Email: enquiry@nianalyticsindia.com