EBS Technology Codelevel Checker (ETCC)

Before an Oracle E-Business Suite 12.2 upgrade or AD/TXK delta, the EBS Technology Codelevel Checker (ETCC) must report zero missing patches on the application tier. Applying those one-offs by hand means separate OPatch sessions on the Forms, Web Tier and Oracle Common homes, plus BSU for WebLogic.

The EBS Technology Patch Automation Tool for the Application Tier (ETPAT-AT), Patch 32208510, does all of it in one run. This post walks through a real run that applied 41 patches in 60 minutes and finished with a clean ETCC report. Long outputs are trimmed; trimmed parts are marked ....

1. Environment

2. Patches to download

Download all of these from My Oracle Support before you start. The tool asks for the last four only after its pre-checks, so staging them early avoids a pause in the middle of the run.

3. Prepare the stage area

3.1Create the stage directory and upload the zips

[applmgr@erpapp01 ~]$ mkdir -p /soft/patches/ETPAT-AT
[applmgr@erpapp01 ETPAT-AT]$ ls -lhtr
total 156K
-rw-r--r-- 1 applmgr oinstall  44K Oct 15 21:43 p32208510_R12_GENERIC.zip
-rw-r--r-- 1 applmgr oinstall 110K Oct 15 21:43 p17537119_R12_GENERIC.zip

3.2Unzip the ETPAT-AT tool

Unzip only the tool. ETPAT-AT unpacks ETCC and the other patches itself.

[applmgr@erpapp01 ETPAT-AT]$ unzip -o p32208510_R12_GENERIC.zip
Archive:  p32208510_R12_GENERIC.zip
  inflating: ErrorDetails.xml
  inflating: etpat_at.pl
  inflating: post_install_steps.xml
  inflating: README.txt

4. Run ETPAT-AT

4.1Start the script and give the context file

Enter the full path of the RUN edition context XML file. A directory path fails with ETPAT-ERR-001, as the first attempt below shows.

[applmgr@erpapp01 ETPAT-AT]$ perl etpat_at.pl

Enter Run edition file system context file:
/u01/oracle/PROD/fs1
Validating the context file...
ETPAT-ERR-001:No valid user-specified context file found.
Action: Specify a valid context file.

Enter Run edition file system context file:
/u01/oracle/PROD/fs1/inst/apps/PROD_erpapp01/appl/admin/PROD_erpapp01.xml
Context file exists: /u01/oracle/PROD/fs1/inst/apps/PROD_erpapp01/appl/admin/PROD_erpapp01.xml
Post install steps file post_install_steps.xml exists under Technology Stack Patching tool stage area
Error Details file ErrorDetails.xml exists under Technology Stack Patching tool stage area

Start Time: Thu Oct 15 21:47:23 +03 2026
File System level is 12.2.0
Sourcing Apps Environment file /u01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_erpapp01.env

4.2APPS credentials and ETCC location

Enter APPS schema name [APPS]:
apps
Enter password for apps schema:
Validating apps user login details...
Password validation is completed

EBS Release level in Database:12.2.0

Enter directory where you downloaded ETCC Patch 17537119:
/soft/patches/ETPAT-AT
ETCC Patch /soft/patches/ETPAT-AT/p17537119_R12_GENERIC.zip exists
... ETCC files unzipped ...
Latest ETCC patch available in ETCC stage area txk_R1220_MT_mappings.xml 120.0.12020000.61 2026/10/06
Platform: LINUX_X86-64

4.3OCM response file

Leave the email blank and accept N. The tool creates ocm.rsp so every OPatch call can run in silent mode.

Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:
The OCM configuration response file (/soft/patches/ETPAT-AT/ocm.rsp) was successfully created.

4.4Choose the WebLogic PSU

The tool generates a WLS inventory and flags an unsupported PSU. Choose the recommended level.

WLS inventory report file: /soft/patches/ETPAT-AT/PROD_etpat_at/log/wlsInventory.txt
Your current WLS PSU version: 10.3.6.0.7
WLS PSU version: 10.3.6.0.7 is not at supported WLS PSU levels. Requires WLS PSU uptake.
Select the WLS PSU you want to upgrade to:
1. JUL25 [10.3.6.0.250715] - Recommended
2. OCT23 [10.3.6.0.231017]
3. APR23 [10.3.6.0.230418]
4. JAN23 [10.3.6.0.230117]
5. JUL22 [10.3.6.0.220719]
6. APR22 [10.3.6.0.220419]
Enter your choice (1 or 2 or 3 or 4 or 5 or 6):
1
You have opted to apply WLS PSU version: 10.3.6.0.250715
Enter 'Yes' to Continue (Yes/No):
yes

4.5Automatic pre-checks

Without further input, the tool saves a pre-patch inventory, confirms the services are down and records the current Web Tier wallet certificate.

Generating pre-update appstier inventory report...
Pre-update Inventory report file: /soft/patches/ETPAT-AT/PROD_etpat_at/log/Appstier_Pre_Inventory_Report.html

Verifying the services status...
AdminServer and NodeManager services are down

Performing Pre wallet checks
Wallet User Certificates Value is : CN=Self-Signed Certificate for EBS_web_PROD_OHS1\20,OU=OAS,O=ORACLE,...
Pre certification check for Wallet completed successfully

4.6Confirm the staged patches

Enter patch stage area:
/soft/patches/ETPAT-AT
Patch stage area exists: /soft/patches/ETPAT-AT

[OPatch patch 6880880. Ensure that p6880880_101000_LINUX.zip, p6880880_111000_Linux-x86-64.zip are downloaded under the patch stage area]
[Fusion Middleware consolidated patch 39034731. Ensure that the patch 39034731 for platform LINUX is downloaded under patch stage area]
[WLS Patch 38073442. Ensure that p38073442_R12_GENERIC.zip is downloaded under patch stage area]
[Smart update Patch 33845432. Ensure that p33845432_R12_GENERIC.zip is downloaded under patch stage area]
Download above patches under patch stage area and Enter 'Yes' to Continue (Yes/No):
yes

Fusion Middleware consolidated patch 39034731 for platform LINUX exists under patch stage area
... bundle unzipped into etcc-bundle/LINUX_X86-64 (forms, webtier, oracle_common, wls) ...
Smart Update Patch p33845432_R12_GENERIC.zip exists under patch stage area
OPatch p6880880_101000_LINUX.zip exists under patch stage area
OPatch p6880880_111000_Linux-x86-64.zip exists under patch stage area
WLS PSU Patch p38073442_R12_GENERIC.zip exists under patch stage area

From here the run is unattended.

5. Patch application

Patching ran from 22:10 to 22:47 (server time, UTC+3), one Oracle home at a time:

5.1Smart Update patch

The tool backs up bsu.sh and raises its heap before patching, which prevents the common BSU out-of-memory failure.

Patching Start Time: Thu Oct 15 22:10:18 +03 2026
Applying WLS smart update patch
Backed up /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsu.sh as /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsu.sh_20261015221018
Memory update required in BSU
MEM_ARGS="-Xms2048m -Xmx5120m -XX:+UseParallelGC"
Smart update patch apply for internal p33800106_1036_Generic.zip
...
Application of WLS Smart update patch is completed successfully

5.2WebLogic PSU 38073442

The new PSU (BSU ID PG6B) conflicted with 9 existing WLS patches. The tool rolled them back in dependency order, then installed the PSU.

Applying WLS Patch PG6B ...
Running command: ... bsu.sh -prod_dir=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3 -patchlist=PG6B -verbose -install ...
WLS conflicts:  YVDZ FCX7 VKXF Y5AP CW9T 1LRI 2GYW BLTG YHJK
Rolling back WLS conflicted patches...
WLS Patch YVDZ rollbacked successfully
CONFLICT DETECTED: Cannot rollback WLS Patch FCX7. Re-attempting the rollback ...
The selected patch cannot be removed until the following patch(es) are removed first: 1LRI,2GYW,CW9T,VKXF,BLTG
... dependent patches removed first, then FCX7, Y5AP, YHJK ...
All WLS conflicts got resolved
Starting installation of Patch ID: PG6B
...
Result: Success
Application of WLS patch 38073442 completed successfully...
Application of WLS PSU completed successfully

5.3ETCC scan: missing one-offs

With the PSU in place, the tool runs ETCC and lists what is still missing.

Running ETCC...
Running ETCC is completed successfully...
MT ETCC log file: /soft/patches/ETPAT-AT/PROD_etpat_at/log/etccLog/checkMTpatch_reconfig_Pre.log

Appstier missing one-offs list:
38429205 FORMS:10.1.2.3.2 LINUX
25342269 FORMS:10.1.2.3.2 Generic
27491934 FORMS:10.1.2.3.2 LINUX
30427122 FORMS:10.1.2.3 LINUX
38073442 WLS:1036 GENERIC
13845626 WLS:10360250715 Generic
...
22288381 FMW-Webtier:11.1.1.9.0 Generic
...
38059622 FMW-Common:11.1.1.9.0 Generic
... 41 entries in total ...
File location: /soft/patches/ETPAT-AT/PROD_etpat_at/log/Report_MissingPatches_Pre.html

5.4Oracle Forms patches (4)

The tool replaces the home’s OPatch (keeping the old one with a timestamp) and applies each patch in silent mode. Patch 38429205 supersedes 3 older patches, which OPatch rolls back automatically.

Applying Oracle Forms patches
Running: mv /u01/oracle/PROD/fs1/EBSapps/10.1.2/OPatch /u01/oracle/PROD/fs1/EBSapps/10.1.2/OPatch_20261015222322
Running: mv /soft/patches/ETPAT-AT/OPatch/forms/OPatch /u01/oracle/PROD/fs1/EBSapps/10.1.2/OPatch

Applying Form patch :38429205
Running command: ORACLE_HOME=/u01/oracle/PROD/fs1/EBSapps/10.1.2; ... opatch apply -silent -ocmrf /soft/patches/ETPAT-AT/ocm.rsp ...
Oracle Interim Patch Installer version 1.0.0.0.64
Patch "38429205" overlays " 14825718 ". Conflict check between them is skipped.
Subset patches:  8557019, 18620223, 19434967,
Rolling back patch 8557019...
Rolling back patch 18620223...
Rolling back patch 19434967...
Back to applying patch 38429205...
...
Inventory is good and does not have any dangling patches.
OPatch succeeded.
Application of patch 38429205 completed successfully ...
... 25342269, 27491934, 30427122 applied the same way ...
Application of Forms patches Completed

5.5Web Tier patches (9)

Patch 32287205 needs a new OHS wallet, so the tool regenerates the wallets first and then patches the Web Tier home.

Wallet generation for OHS
Patch number of wallet: 32287205
Executing wallet function steps prior to OHS Patch application
wallet creation return value is 0
Subject:        CN=FMWSmallCircleOfTrust
...
Applying Webtier patches
Running: mv /u01/oracle/PROD/fs1/FMW_Home/webtier/OPatch /u01/oracle/PROD/fs1/FMW_Home/webtier/OPatch_20261015222551

Applying WebTier patch: 22288381
OPatch version    : 11.1.0.12.9
Interim patch 22288381 is a superset of the patch(es) [  20922780 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
...
Patch 22288381 successfully applied
OPatch succeeded.
Application of patch 22288381 completed successfully
... 35540062, 32287205, 23716938, 32928416, 33144848, 34067016, 39963933, 22290164 ...
Application of Webtier patches Completed

5.6Oracle Common patches (21)

This is the largest group. Each patch took 10 to 40 seconds.

Applying Oracle Common patches
Application of patch 38059622 completed successfully
Application of patch 31973206 completed successfully
Application of patch 9905685 completed successfully
... 15 more ...
Application of patch 39963933 completed successfully
Application of patch 40090834 completed successfully
Application of patch 39959053 completed successfully

5.7WebLogic one-off patches (6)

These go in through BSU on top of the new PSU, with no further conflicts.

Applying WLS patches
Applying WLS Patch 4HID ...
Checking for conflicts..
No conflict(s) detected
Starting installation of Patch ID: 4HID
Result: Success
Application of WLS patch 13845626 completed successfully..
Application of WLS patch 22323006 completed successfully..
Application of WLS patch 34856303 completed successfully..
Application of WLS patch 35476084 completed successfully..
Application of WLS patch 31042881 completed successfully..
Application of WLS patch 39985645 completed successfully..

6. Post-patch validation

The tool re-checks the wallet, runs ETCC again and writes a post-patch inventory. The key line is missing one-offs list: 0.

Performing Post Wallet Checks
Wallet User Certificates Value is : CN=FMWSmallCircleOfTrust
Post certification check for Wallet completed successfully

Post patching validations....
Running ETCC...
MT ETCC log file: /soft/patches/ETPAT-AT/PROD_etpat_at/log/etccLog/checkMTpatch_reconfig_Post.log
Post-update Appstier missing one-offs list: 0
File location: /soft/patches/ETPAT-AT/PROD_etpat_at/log/Report_MissingPatches_Post.html

Post-update Inventory report file: /soft/patches/ETPAT-AT/PROD_etpat_at/log/Appstier_Post_Inventory_Report.html

Initial missing patches: 38429205 25342269 27491934 30427122 22288381 ... (41)
List of patches applied: 38429205 25342269 27491934 30427122 22288381 ... (41)
All missing one-offs got applied and ETCC report is clean

Summary report html file location: /soft/patches/ETPAT-AT/PROD_etpat_at/log/ETPAT-AT_Report_PROD.html
End Time: Thu Oct 15 22:47:16 +03 2026
Script etpat_at.pl ran successfully.

Then start the application tier and do a quick functional check:

[applmgr@erpapp01 ~]$ . /u01/oracle/PROD/EBSapps.env run
[applmgr@erpapp01 ~]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@erpapp01 scripts]$ ./adstrtal.sh apps/<apps_password>

Log in to EBS, open a Forms-based responsibility, and check the WebLogic console. On a multi-node install, sync the other application nodes as your upgrade plan requires.

7. Log and report files

All files are under /soft/patches/ETPAT-AT/PROD_etpat_at/log/. Keep them with your upgrade records.

8. Issues and fixes

9. Best practices

• Download the latest ETCC (17537119) on the day of the run. Its mapping files change often.
• Stage all six patches before starting, so the run never stops waiting for a download.
• Choose the PSU marked Recommended to avoid another WebLogic patch cycle soon after.
• Run inside screen or tmux and log the session.
• Rehearse on a clone of production first. You’ll know the timing and any conflicts in advance.
• Keep the timestamped OPatch_* folders and bsu.sh_* backup until the upgrade is signed off.

Reference: My Oracle Support KA1167, EBS Technology Patch Automation Tool for Application Tier (ETPAT-AT).