Oracle EBS 11i,R12.1 and R12.2 Part-1

Introduction: Oracle EBS is an ERP (Enterprise Resource Planning) application suite used to integrate different functionalities in an organization. It has different modules to serve the business requirements based on licensing. Those are as below.

1. Financial Modules

2. Supply Chain Management

3. CRM (Customer Relational Module)

4. HRMS (Human Resource Management Systems)

Functional, Technical and DBA are the different roles to maintain, manage and support oracle applications.

Architecture: In R12.2 weblogic was replaced with OC4J (Oracle Component 4 Java).Apache is the OHS server (Oracle HTTP Server, simply route the http requests to weblogic server i.e., acts as a proxy server)

Weblogic server (Admin server) contains oacore_server, forms_server, forms_c4ws_server and oafm_server managed servers.

oacore_server - This runs the OA Framework -based applications.

Forms _server- This runs the Forms-based applications.

Forms-c4ws_server - Oracle Forms-based functionality as web services.

Oafm_server - This is responsible for running the web services.

File System: R12.2 has dual file system RUN and PATCH, by default fs1 is the RUN file system and fs2 PATCH system (it can switch at the time of patches apply). fs_ne was the common file system and it contains log files (patch, concurrent request log files etc.,).

IAS_ORACLE_HOME (10.1.3) replaced with FMW home and it contains all binaries, executables to run weblogic and managed servers. ORACLE_HOME (10.1.2) contains binaries, executables for forms and reports.

AD (APPS DBA) Utilities:

To manage oracle applications APPS DBA will use these AD utilities.

adadmin: Performs maintenance tasks on the application file system and Database.

            AD Administration Main Menu

   --------------------------------------------------

1.        Generate Applications Files menu

·         Generate message files

·         Generate form files

·         Generate report files

·         Generate product JAR files

·         Return to Main Menu

   2.    Maintain Applications Files menu

·         Relink Applications programs

·         Copy files to destinations

·         Convert character set

·         Maintain snapshot information

·         Check for missing files

·         Return to Main Menu

   3.    Compile/Reload Applications Database Entities menu

·         Compile APPS schema

·         Compile menu information

·         Compile flexfields

·         Reload JAR files to database

·         Return to Main Menu

   4.    Maintain Applications Database Entities menu

·         Validate APPS schema

·         Re-create grants and synonyms for APPS schema

·         Maintain multi-lingual tables

·         Check DUAL table

·         Return to Main Menu

   5.    Exit AD Administration

adctrl: Manage workers and assigning job to the workers, also possible to know the status of the worker.

AD Controller Menu

---------------------------------------------------

1. Show worker status

2. Tell worker to restart a failed job

3. Tell worker to quit

4. Tell manager that a worker failed its job

5. Tell manager that a worker acknowledges quit

6. Restart a worker on the current machine

7. Exit

adident: Shows file version

Usage: adident Header <file name>

adpatch (11i & R12.1)/adop (R12.2): Utility to apply the application patch

adautocfg.sh: Used to run autoconfig on applications. Changes will effect to the applications after running autoconfig.

admrgpch: Used to merge the patches in 11i and R12.1 applications. Obsolete in R12.2

Patching: Online patching concept was introduced in R12.2. “adpatch” utility replaced with “adop”. Will apply patch on hotpatch mode if its read me recommends. Otherwise will apply it on normal mode.

Hotpatch Mode: Patch will apply on RUN filesystem and the syntax is as below.

adop phase=apply patches=<patch number> hotpatch=yes workers=12 (optional, by default 32 workers will do the task).

Normal Mode: Patch will apply on PATCH filesystem and the syntax is as below.

adop phase=prepare : Synchronizes PATCH & RUN edition file systems. Creates a new patch edition in the database.

adop phase=apply patches=<patch number> or <patch number:upatchno.drv>,<patch number:upatchno.drv> etc., (multiple patches)

adop phase=finalize: Compiles invalid objects and generates derived objects

adop phase=cutover : Configure patch edition  file system and database to the new run edition file system. Restart application services

adop phase=cleanup : Delete obsolete code to recover space

*adop phase=fs_clone is a standalone command to invoke on the RUN file system. The purpose of this phase was to synchronize RUN and PATCH file systems, mostly after applying patches in hotpatch mode.

Types of Patches:

1.      One-Off Patch: It is a bug fix patch and size would be in KB’s.

2.      Mini Patch: Fix or latest enhancements for particular product i.e, AP,AR,GL etc.,

3.      Family Patch: Fix or latest enhancements for particular family i.e., Financials (AP,AR,GL,FA) etc.,

4.      Interoperability Patches: Compatibility related patches. Applications will install with the default Database (Eg: 11i (11.5.10.2) applications default database was 9i (9.2.0.6)).If we want to upgrade higher version of the database then need to apply these patches on database and applications.

5.      Maintenance Patch: Upgrade patch, will upgrade from a lower version to higher version.

6.      TechStack Patches: Applicable to applications ORACLE_HOME & FMW home (opatch is the utility will use to apply these patches).