Introduction
Oracle E-Business Suite (EBS) Release 12.2 requires periodic updates to its Application DBA (AD) and Technology Stack (TXK) components to maintain security, stability, and Oracle support compliance.
AD and TXK Release Update Packs (RUPs) deliver important fixes related to online patching, database connectivity, technology stack components, and application maintenance activities.
This article explains the practical approach followed to upgrade an Oracle EBS R12.2 environment from an earlier AD/TXK code level to:
| Component | Patch Number | Target Code Level |
| AD Delta 16 | 36119925 | R12.AD.C.Delta.16 |
| TXK Delta 16 | 36117775 | R12.TXK.C.Delta.16 |
The implementation follows Path B from Oracle Knowledge Article KA1061 – Applying a Non-Current Version of the AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2.
1. Patch Download and Preparation
Download the required AD and TXK patches into the standard EBS patch staging location:
$NE_BASE/EBSapps/patch
Required patches:
36119925 – R12.AD.C.Delta.16
36117775 – R12.TXK.C.Delta.16
Ensure all prerequisite patches, recommended fixes, and ETCC-required database patches are available before starting the upgrade activity.
2. Database Readiness Validation
2.1 Run ETCC Database Patch Validation
Before applying AD/TXK patches, validate the database tier using the E-Business Suite Technology Codelevel Checker (ETCC).
ETCC is available through: Patch 17537119
Execute: checkDBpatch.sh
Review the output and apply all missing database patches.
Reference: Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Database Patches and Bug Fixes (Document ID 1594274.1)
2.2 Database Parameter Configuration
For supported Oracle database versions, configure the following parameter:
_disable_actualization_for_grant=true
Applicable versions:
- Oracle Database 19c
- Oracle Database 12.1.0.2
- Oracle Database 11.2.0.4
- Oracle AI Database 26ai
This parameter ensures proper grant actualization behavior during EBS patching activities.
3. Prepare Patch File System
Verify the active file system:
echo $FILE_EDITION
Expected output: run
Apply required permissions on the patch file system:
cd $PATCH_BASE/EBSapps
chmod -R 755 10.1.2
Perform this activity on:
- Primary application node Patch File System
- Secondary application node Patch File System
Note: Do not modify permissions on the Run File System.
4. Complete Existing Patch Cycle Activities
Before applying AD/TXK patches, ensure there is no active patching session.
Check ADOP status: adop -status
Execute an empty patch cycle:
adop phase=prepare
adop phase=actualize_all
adop phase=finalize finalize_mode=full
adop phase=cutover
adop phase=cleanup cleanup_mode=full loglevel=statement
Validate invalid database objects:
select count(*)from dba_objectswhere status=’INVALID’;
5. Execute AD Grants Script
Copy the latest AD grants script:
cp <PATCH_TOP>/36119925/admin/adgrants.sql \$ORACLE_HOME/appsutil/admin/
Source database environment:
source $ORACLE_HOME/<CDB_NAME>_<hostname>.env
export ORACLE_PDB_SID=<PDB_NAME>
Run:
sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS
After completion:
unset ORACLE_PDB_SID
6. Apply ETCC Middleware and Application Tier Fixes
Start a new patch environment:
. /u11/app/TEST/R12apps/EBSapps.env patch
Verify:
echo $FILE_EDITION
echo $TWO_TASK
Expected:
FILE_EDITION = patch
TWO_TASK = TEST_patch
Run the below:
sh checkMTpatch.sh
7. Apply Oracle Forms and Reports Patches
Oracle Forms and Reports Oracle Home:
$ORACLE_HOME
Required patches: 30427122, 38429205
Apply Patch 30427122
cd $PATCH_TOP/30427122
opatch apply
Execute post-installation script:
sh patch.sh
Apply Patch 38429205
cd $PATCH_TOP/38429205
opatch apply
8. Apply Oracle Common Middleware Patches
Oracle Common Home:
$FMW_HOME/oracle_common
Existing patch rollback: 33960746
New patches: 38059622, 31973206, 34714760, 38030906
Rollback old patch:
opatch rollback -id 33960746
Apply new patches: 38059622, 31973206, 34714760, 38030906
opatch apply
9. Apply WebLogic Server Updates
WebLogic Home:
$FMW_HOME/wlserver_10.3
Target patch: 33946345
Copy required BSU files:
cp patch-catalog_27852.xml \$FMW_HOME/utils/bsu/cache_dir
cp T64V.jar \$FMW_HOME/utils/bsu/cache_dir
Additional patches: 13964737, 13845626
Required patch IDs:
T64V
N3YF
UCI6
Remove Existing WebLogic Fixes
Remove:
7GCA
IJC1
HYG5
Example:
bsu.sh -remove \-patchlist=7GCA \-prod_dir=$WL_HOME
Install New WebLogic Fixes
Example:
bsu.sh \-prod_dir=$WL_HOME \-patch_download_dir=$MW_HOME/utils/bsu/cache_dir \-patchlist=T64V \-verbose \-install
Repeat for:
N3YF
UCI6
10. Apply AD Delta 16 Release Update Pack
Patch: 36119925
Verify environment:
echo $FILE_EDITION
Apply AD patch along with critical fixes:
adop phase=apply \patches=36119925,38128194,36303698,36989014,37988551,37964268 \merge=yes
Additional AD patches:
| Patch |
| 38128194 |
| 36303698 |
| 36989014 |
| 37988551 |
| 37964268 |
11. Apply TXK Delta 16 Release Update Pack
Patch: 36117775
Apply:
adop phase=apply \patches=36117775,36641685,37500697 \merge=yes
Additional TXK patches:
| Patch |
| 36641685 |
| 37500697 |
12. Verify AD and TXK Code Levels
Run:
SELECT ABBREVIATION, NAME, CODELEVELFROM AD_TRACKABLE_ENTITIESWHERE abbreviation IN (‘txk’,’ad’,’atg_pf’);
Expected:
AD C.16
TXK C.16
ATG_PF C.9
13. Complete Online Patching Cycle
Execute:
adop phase=finalize
adop phase=cutover mtrestart=no
Validate invalid objects:
select count(*)from dba_objectswhere status=’INVALID’;
14. Update Database Tier AutoConfig
Run AutoConfig on:
- Primary Application Node
- DMZ Node
- Database Node
Generate appsutil:
perl $AD_TOP/bin/admkappsutil.pl
Copy appsutil.zip:
cp appsutil.zip appsutil.zip_bkp
cp <INST_TOP>/admin/out/appsutil.zip .
Extract:
unzip -o appsutil.zip
Run database AutoConfig:
$ORACLE_HOME/appsutil/scripts/<CONTEXT_NAME>/adautocfg.sh
15. Application Startup and Cleanup
Start:
- Primary Application Services
- DMZ Application Services
Verify:
echo $FILE_EDITION
Expected: run
Execute cleanup:
adop phase=cleanup
16. File System Synchronization
Synchronize Run and Patch file systems:
adop phase=fs_clone force=yes
Post Upgrade Validation Checklist
After completing AD/TXK Delta 16 upgrade:
Verify AD and TXK code levels
Confirm no invalid database objects
Validate Application login
Verify Forms and OAF functionality
Check Concurrent Managers
Validate Workflow Mailer
Review WebLogic services
Execute ETCC validation again
Review ADOP logs using adopscanlog
Conclusion
Upgrading AD and TXK components in Oracle E-Business Suite R12.2 requires careful planning, database validation, middleware patching, and controlled execution of online patching phases.
Following a structured approach helps minimize downtime, reduces patching risks, and ensures that the EBS environment remains secure, stable, and aligned with Oracle support recommendations.
