Introduction

What is Oracle Applications

Hey Buddies,

This is Susheel.  

I am an Oracle Apps DBA from Hyderabad, INDIA. In this Blog you will find posts that are related to my work and reference queries which help me in my day to day life. Lets get started of with understanding "What is Oracle Applications?"

Oracle Apps is an Enterprise Resource Planning (ERP) that caters to overall business need of an enterprise in the areas of Finance, Supply Chain Management,HRMS, Customer Relationship Management etc.  Oracle released an enterprise product called Oracle Application EBusiness suite. 

 Initially Oracle became very popular in Financial services industry as its financial modules like AP,AR and GL covers all major business processes in Financial domain. With that reputation,Oracle has expanded its presence in ERP space with introduction of Supply chain(PO,INV & Order management),Project accounting (Project costing,Project Billing and Project resource Management),HRMS(HR,SSHR,Oracle Advanced Benefits,Oracle time and Labour) and CRM modules.

    Oracle Application - Real time projects are classified into three major categories.

1. Oracle application Implementation (Starting form Initial system study to Go-live, In terms of duration-minimum six months)

2. Oracle Application Upgrade (Upgrading Oracle Application from One version to another like Oracle apps 11i to Oracle apps R12; Duration : based on complexity of upgrade with minimum period of four months)

3. Oracle application support (Oracle Apps Maintenance after Go-live.Not much challenging,only bug fixing or report development)

There will be three main roles that all consultants will be placed in Oracle apps real time projects

1. Functional consultant : Consultant with domain knowledge in Financials,Supply Chain will take the functional consultant role and do the Oracle apps implementation. Those who would like to become Functional consultant, prior domain experience is mandatory and then take the training in Oracle apps to understand the real time business process mapping in Oracle Apps.

2. Technical consultant : Consultant with technical knowledge like PL/SQL and  Reports development can become technical consultant. Their role in implementation is on  new reports development,Interface between Oracle Apps and Third party legacy systems. Basic knowledge in PL/SQL is mandatory to become technical consultant. Now a days Oracle is moving R12 version which is predominantly in Java technology and hence it will be good to have Java exposure to become technical consultant.

3. Database Administrators : Database Administrators will maintain Oracle Apps Database with activities like  periodic backup, system recovery , Patch management ,raising service request with Oracle on any major application issues and Performance tuning. Those who worked as Oracle DBA is a minimum pre requisite to become Oracle Apps DBA.

A typical Oracle Apps Implementation goes through the following phases.

1. Gap analysis

2. Solution design

3. Build

4. Conference room Pilot(Testing)

5. Go-Live