Oracle Applications DBA

Oracle Applications DBA

How to become an Oracle Applications DBA

 

An Oracle Applications DBA is very different from a regular Oracle database administrator and requires specialized skills in business administration and Oracle application server architectures.  The Oracle Applications DBA job role is less compartmentalized than a traditional Oracle DBA and the Oracle Applications DBA must also have skills in these areas:

• Database Design - Many shops require customized functional extensions and reporting data marts and the Oracle Applications DBA must have outstanding Database design skills.
   
• Oracle Application Server - The Oracle Applications DBA must understand the internals of the Oracle concurrent manager and understand how to monitor and tune Oracle Applications.
   
• Functional Expertise - Many shops requires a business degree and a general understanding of the Oracle Applications module.  For example, accountants are widely used to support Oracle eBusiness Suite (Oracle Financials), and accountants with an IT background are easily trained in Oracle Applications DBA support.
  

 

Oracle Applications DBA modules

There are over 130 Oracle Applications Modules offered with Oracle Applications and the Oracle Applications DBA must have an understanding of the functional and internal machinations of the Oracle Applications software.  For example, Oracle EBusiness Suite (Oracle Financials) applications DBA staff must understand basic cost and financial accounting, especially in cases where they create reporting databases and assist in expanding the functionality for specialized accounting.  Many of these Oracle Financials DBA's are certified public accountants (CPA).

Oracle Applications DBA background

Because most Oracle Applications databases support mission critical systems, a successful Oracle Applications DBA must have these skills:

• Outstanding Communications Skills - Oracle Applications DBA's must interface with the end-user community and they must have college-level communications skills, being able to communicate clearly, both orally and with written communications.  .
   
• DBA skills - Most Oracle Applications DBA staff have at least five years of full-time progressive DBA experience, and they sometimes have Oracle certifications such as OCP and OCM. The Oracle Applications DBA must also have a good understanding of related technologies, especially Java (JDeveloper, J2EE, Apache) and Oracle Application Server.

Oracle Applications is one of the worlds most complex ERP tools with over 130 specific business functional areas. Oracle Applications modules:

ABM - Activity Based Management 
AD - Applications DBA 
AHL - Oracle Advanced Service Online 
AK - Oracle Common Modules-AK 
ALR - Oracle Alert 
AMF - Oracle Fulfillment Services 
AMS - Oracle Marketing 
AP - Oracle Payables 
AR - Oracle Receivables 
AS - Oracle Sales 
ASG - Oracle CRM Gateway for Mobile Services 
ASL - Oracle Mobile Field Sales Laptop 
ASO - Oracle Order Capture 
AST - TeleSales 
AX - Global Accounting Engine 
AZ - Application Implementation 
BEN - Oracle Advanced Benefits 
BIC - Customer Intelligence 
BIL - Sales Intelligence 
BIM - Marketing Intelligence 
BIS - Oracle Applications BIS 
BIX - Call Center Intelligence 
BNE - Oracle Web ADI 
BOM - Oracle Bills of Material 
BSC - Balanced Scorecard 
CCT - Oracle Call Center and Telephony 
CE - Oracle Cash Management 
CHV - Oracle Supplier Scheduling 
CLN - Supply Chain Trading Connector for RosettaNet 
CN - Oracle Sales Compensation 
CS - Oracle Service 
CSC - Customer Care 
CSD - Depot Repair 
CSE - Oracle Enterprise Install Base 
CSF - Field Service 
CSI - Install Base 
CSM - Oracle Field Service Palm 
CSP - Oracle Spares Management 
CSR - Oracle Scheduler 
CSS - Support 
CUG - Oracle Citizen Interaction Center 
CUN - Oracle Network Logistics NATS 
CZ - Oracle Configurator 
EAM - Oracle Enterprise Asset Management 
EC - Oracle e-Commerce Gateway 
ECX - Oracle XML Gateway 
EDR - Oracle E Records 
ENG - Oracle Engineering 
FII - Financials Intelligence 
FLM - Oracle Flow Manufacturing 
FND - Application Object Library 
FTE - Oracle Transportation Hub 
FV - Oracle Federal Financials 
GHR - Oracle Federal HR 
GL - Oracle General Ledger 
GMA - Oracle Process Manufacturing Systems 
GMD - Oracle Process Manufacturing Product Development 
GME - Oracle Process Manufacturing Process Execution 
GMF - Oracle Process Manufacturing Financials 
GMI - Oracle Process Manufacturing Inventory 
GML - Oracle Process Manufacturing Logistics 
GMP - Oracle Process Manufacturing Process Planning 
GMS - Oracle Grants Accounting 
GR - Oracle Process Regulatory Mgmt 
HRI - Human Resources Intelligence 
HXC - Oracle Time and Labor 
HXT - Oracle Time and Labor Rules 
IBA - iMarketing 
IBC - Oracle iContent 
IBE - iStore 
IBU - iSupport 
IBY - iPayment 
ICX - Oracle Self-Service Web Applications 
IEB - Oracle Interaction Blending 
IEC - Oracle Campaign Plus 
IEM - Oracle eMail Center 
IEO - Call Center Technology 
IES - Scripting 
IEU - Oracle Universal Work Queue 
IEX - Oracle Collections 
IGC - Commitment Administration 
IGF - Student Systems Fin Aid 
IGI - Oracle International Public Sector Financials 
IGS - Oracle Student Sytems 
IGW - Oracle Grants Proposal 
INV - Oracle Inventory 
IPD - Oracle Product Development Exchange 
ISC - Supply Chain Intelligence 
JTF - CRM Foundation 
JTM - Oracle CRM Mobile Foundation 
JTS - Oracle CRM Self Service Administration 
MRP - Oracle Master Scheduling/MRP 
MSC - Oracle Advanced Supply Chain Planning 
MSD - Oracle Demand Planning 
OFA - Oracle Assets 
OKC - Oracle Contracts Core 
OKI - Oracle Contracts Intelligence 
OKL - Oracle Lease Management 
OKR - Oracle Contracts for Rights 
OKS - Oracle Contracts Service Module 
ONT - Oracle Order Management 
OPI - Operations Intelligence 
OTA - Oracle Training Administration 
OZF - Funds & Budgets 
PA - Oracle Projects 
PAY - Oracle Payroll 
PER - Oracle Human Resources 
PJM - Oracle Project Manufacturing 
PN - Oracle Property Manager 
PO - Oracle Purchasing 
POA - Purchasing Intelligence 
POM - Oracle Exchange 
PON - Oracle Sourcing 
POS - Internet Supplier Portal 
PQH - Oracle Public Sector HR 
PSA - Public Sector Applications 
PSB - Oracle Public Sector Budgeting 
PSP - Oracle Labor Distribution 
PV - Partner Relationship Management 
QA - Oracle Quality 
QP - Oracle Pricing 
QRM - Oracle Risk Management 
RG - Application Report Generator 
RLM - Oracle Release Management 
VEA - Oracle Automotive 
WIP - Oracle Work in Process 
WMS - Oracle Warehouse Management System 
WSH - Oracle Shipping 
WSM - Shop Floor Management 
XDP - Oracle Provisioning 
XNC - Oracle Sales for Communications 
XNI - Oracle Install Base Intelligence 
XNP - Oracle Number Portability 
XNS - Oracle Service for Communications 
XTR - Oracle Treasury