What is Oracle Applications/Oracle E-Business Suite ?
To facilitate big businesses, Oracle Corporation have created collection of software in
the category of ERP (Enterprise Resource Planning) known as modules, that are
integrated to talk to each other and known as Oracle Applications or E-Business
Oracle E-Business Suite Releases:
10.7 : Oldest Release of Oracle ERP which is character, thin client based. Oracle has
stopped support for this release from year 1998.
R12 : Latest Release Of EBS by Oracle .
Oracle EBS R12 Applications is a three-tiered architecture.
1.Desktop Tier – Forms Client Applet,Desktop Java Client(sun JRE)
2.Application Tier – containing the application server(TechStack components – Apache,Forms,Report,CMs).
3.Database Tier – containing the database (stand-alone or RAC).
Common Tasks of Apps DBA:
Configuring -License manager,adsplice,autoconfig,context editor..etc
Maintaining – AD utilities like adadmin,adrelink,adcmctl..etc
Application Patching – – family packs/mini packs/maintenance packs etc.
Troubleshooting on day-to-day activities.
Monitoring the Concurrent Managers queue
Changing the Oracle Apps Passwords.
Monitor Workflow related services.
R12 EBS Directory Structure
Techstack Components :
– 10.2.0.2 RDBMS ORACLE_HOME
– 10.1.2 C ORACLE_HOME / FORMS ORACLE_HOME (8.0.6 ORACLE HOME as in
– 10.1.3 Java ORACLE_HOME/OC4J ORACLE_HOME (iAS ORACLE_HOME as in
– INSTANCE_TOP : Each application tier has a unique Instance Home file system associated
URL to access E-Business Suite : http://<web server host name>.<domain>:<port number>
How to find above URL in database
QUERY : SELECT home_url FROM icx_parameters;