Monday, March 21, 2011

Roles In Oracle Apps

In oracle apps there are 3 roles
1) Functional Consultant
2) Technical Consultant
3) DBA(Database Administrator)

In oracle apps these are the basic modules
AP -> Account Payables  
AR -> Account Receivables 
GL -> General Ledger
FA -> Fixed Assets 
CM -> Cash Management 
INV -> Inventory
PO  -> Purchasing Order
OM  -> Order Management
BOM -> Bill Of Material
WIP -> Work In Progress
HRMS -> Human Resource Management and  PAYROLL

If you understand the full functional flow of any one particular module say AP then you are functional consultant in AP module.Functional people know how to navigate the front end and how to create an entry in front end.They collect requirements from direct client and the collected requirements passed to Technical Consultant in the written format called MD050 document.Tools used by functional consultant are browser( to view the front end).

All the data entered by functional consultant stored in the database tables.So,the job of techncial consultant is to navigate through the tables affected for that particular entry.Technical consultant design the reports,interfaces,form customizations components.After completing their task technical consultant people create a document to end user called MD070 document.This contains the coding part and the steps how to run the program.Tools used by technical consultant are Toad(to communicate with database),Browser(To see the front end),Transfer Client like (Filezilla),Putty,Oracle Reports Developer,Form Developer, SQL Devloper.

After knowing what is functional consultant and technical consultant everyone's mind trigger to this question called which one is best either functional or technical...In my point of view both are important

DBA(Database administrator's) maintain the oracle apps server and he maintain the security type of issues.

Refer this link in which consultant you want to be a?
Refer this link to know the pre-requistes to be a technical consultant?


  1. This comment has been removed by the author.

  2. This post gives idea about the roles in Oracle Apps. It has three rules which are explained in the post. The rules are simple so I don't think you have any difficulty in understanding them. This work requires appreciation. Keep it up.
    sap migration

  3. I am Sridevi Koduru, Senior Oracle Apps Trainer at With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

    Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K at | | +91-9581017828 |

    Linkedin profile -

  4. Hi,
    Thank you fo sharing the useful information roles in oracle apps to all users .continue posting articles like this .
    Thank you.
    oracle R12 training

  5. Oracle fusion HCM Training from ERPTREE gives you the best results to learn your dream course and maintains sufficient knowledge on oracle. It provides training by self-paced videos which are very helpful for the users to watch at any time according to their schedule. It is globally accepted and having many users undergoing
    training every day.

    Oracle fusion HCM Online Training

    Oracle Fusion HCM Training