EBS Technology Code Checker ETCC for EBS 12.2

Download the latest ETCC (EBS Technology Code Checker) patch p17537119_R12_GENERIC.zip

The scripts are usually updated on a quarterly basis as mentioned in note 

12.2 E-Business Suite Applications DBA Steps To Run The EBS Technology Code Level Checker (ETCC) (Doc ID 2008451.1)

This patch provides two scripts, together referred to as ETCC, that help ensure you have the required da

tabase and middle tier bugfixes

installed for your Oracle E-Business Suite Release 12.2 system.

ETCC maps missing bugfixes to corresponding patches for the latest and latest but one quarterly bundles

supported by Oracle E-Business Suite Release 12.2. Refer to Doc ID 1594274.1 "Section 3: Database Patches and Bug Numbers" for the Oracle database releases and bundle documentation.

When running DB-ETCC on Oracle Cloud Infrastructure, use the "cloud=y" command line option.

Example: checkDBpatch.sh contextfile=<file> cloud=y

DB-ETCC will automatically identify the cloud service.   The service can be specified manually using the "service=<service>" parameter.

Example: checkDBpatch.sh contextfile=<file> [cloud=y service=<service>]

cloud=y service=[dbcs]    : Database Cloud Services (DBCS) - Single Instance

                [dbcsrac] : Database Cloud Services (DBCS) - Real Application Clusters

                [exacs]   : Exadata Cloud Services (ExaCS)

                [dbsi]    : Database System - Single Instance (DBSI)

                [vmdbrac] : Virtual Machine DB System - Real Application Clusters

                [exabm]   : Exadata DB System (EXABM)

                [exacc]   : Exadata Cloud at Customer (EXACC)

Using DB Technology Codelevel Checker (DB-ETCC)

If it does not already exist, create the <RDBMS_ORACLE_HOME>/appsutil/etcc directory

Interactive mode:

      $ ./checkDBpatch.sh

    Oracle Cloud Infrastructure use only:

      $ ./checkDBpatch.sh cloud=y service=[dbcs|dbcsrac|dbsi|exacs|exabm|exacc|vmdbrac]

\

Using MT Technology Codelevel Checker (MT-ETCC)

  Source the correct environment for the applicable scenario (install/upgrade, or online patching cycle).

  Change directory to the location where the ETCC files were unzipped.

  Run the MT-ETCC script.

   To run in interactive mode:

            $ ./checkMTpatch.sh

        To run in non-interactive mode:

            $ (echo <appspass>) |./checkMTpatch.sh contextfile=<full path to middle tier context file>

In a multi-node Oracle E-Business Suite environment, you need to run MT-ETCC:

  - On all non-shared application (middle) tier nodes.

  - On any one of the shared application (middle) tier nodes.

Usage Examples for DB-ETCC and MT-ETCC

DB Technology Codelevel Checker (DB-ETCC) - Missing bugfixes have been identified.

DB Technology Codelevel Checker (DB-ETCC) - All required bugfixes have been applied.

MT Technology Codelevel Checker (MT-ETCC) - Missing bugfixes have been identified.

MT Technology Codelevel Checker (MT-ETCC) - All required bugfixes have been applied.

Any missing bug fixes/patches that are listed in the above output must be resolved by applying the patches to various components that are database, weblogic, forms, oracle_home, etc. 

References: 

How To Find The Version Of Oracle Fusion Middleware Used By E-Business Suite 12.2 (Doc ID 2073977.1)

12.2 E-Business Suite Applications DBA Steps To Run The EBS Technology Code Level Checker (ETCC) (Doc ID 2008451.1)

If the EBS Technology Code Level Checker reports a missing bug fix, you can identify the patch that includes the missing fix by referring to the following note
Note 1594274.1 - Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes

If some RDBMS patches are in conflict when applying a missing bug fix, the following Notes may help or a dedicated Service Request can be raised to E-Business Installation Support team for further investigation:
    - Note 1147107.1 - Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
    - Note 1321267.1 - Database Patch Conflict Resolution
    - Note 1091294.1 - How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video]