REFERENCES :-
============
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Database Patches and Bug Fixes
Document 2877607.1, Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Bug Fixes
Document 2755875.1, Oracle E-Business Suite Release 12.2 System Schema Migration
Document 2758999.1, FAQ: Oracle E-Business Suite Release 12.2 System Schema Migration
Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (July 2023) (Doc ID 2953580.1)
************** START OF AD & TXK DELTA 14 PATCHES **************
Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)
================================================================================
select abbreviation, name, codelevel from ad_trackable_entities where abbreviation in( ‘ad’,’txk’,’atg_pf’,’pay’,’okc’,’hz’) order by abbreviation;
ABBREVIATI NAME CODELEVEL
———- ————————————————– ——————–
ad Applications DBA C.12
atg_pf Oracle Applications Technology Family C.9
hz Oracle Trading Community C.5
okc Oracle Contracts C.5
pay Oracle Payroll C.7
txk Oracle Applications Technology Stack C.12
Apply Required Database Patches
=========================
Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Database Patches and Bug Fixes (Doc ID 1594274.1)
Section 2: Using the latest EBS Technology Codelevel Checker (ETCC) from Patch 17537119.
cd /u01/Patches/ETCC_July_2023
sh checkDBpatch.sh
==> We are already in “Version 19.20.0.0.0” which is latest version and certified by oracle.
Section 4: Database Patches and Bug Numbers on Linux x86-64
Section 4.1: Database 19.0.0.0 Patches and Bug Numbers
We are already in “Version 19.20.0.0.0” which is latest version and certified by oracle.
Set Database Parameters:
===================
The following optimizer parameter should always be set to a value of TRUE, as shown here in the database initialization file:
_disable_actualization_for_grant=true
SQL> show parameter _disable_actualization_for_grant
NAME TYPE VALUE
——————————————– ———– —————————–
_disable_actualization_for_grant boolean TRUE
Apply R12.AD.C.Delta.14 and R12.TXK.C.Delta.14 Release Update Packs
====================================================
echo $FILE_EDITION ==> RUN
adop -status -detail
adop phase=prepare
Run ETCC
==========
Note : Check ETCC on Patch FS ( not in Run FS) Before Applying Next Patches.
Using the latest EBS Technology Codelevel Checker (ETCC) from Patch 17537119.
Run MT-ETCC checker – checkMTpatch.sh and Apply the missing Application tier technology patches on the “Patch FS”
Also, refer to the list of Apps TechStack patches from the “Doc ID 2877607.1 :Oracle E-Business Suite Release 12.2: Consolidated List of Oracle Fusion Middleware Patches and Bug Fixes”
echo $FILE_EDITION ==> PATCH
cd /u01/Patches/ETCC_July_2023
sh checkMTpatch.sh
==> All required one-offs are confirmed as present.
Run “adgrants.sql” as oracle user
=========================
Run the latest version of the adgrants.sql script, which will grant the required privileges and also create the EBS_SYSTEM schema if it does not already exist
Copy the adgrants.sql script from Patch 34669333 to the database tier server (if the adgrants.sql from the patch dir is higher)
$ cp $PATCH_TOP/34669333/admin/adgrants.sql $ORACLE_HOME/appsutil/admin/
On the database tier server as “oracle” user
source $ORACLE_HOME/<CDB_NAME>_<HOSTNAME>.env
export ORACLE_PDB_SID=<EBS PDB Name>
cd $ORACLE_HOME/appsutil/admin/
sqlplus /nolog
SQL> @adgrants.sql APPS
sqlplus / as sysdba
ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
ALTER USER EBS_SYSTEM IDENTIFIED BY password123; Note: EBS_SYSTEM password to be the same as the SYSTEM password.
On the application tier server as “applmgr” user
———————————————–
echo $FILE_EDITION ==> RUN
perl $PATCH_TOP/33600809/ad/bin/adValidateEbssystemSchema.pl
==> All required validations completed successfully
Apply R12.AD.C.Delta.14 & AD critical patches at the same time :
=================================================
echo $FILE_EDITION ==> RUN
adop -status -detail
echo $PATCH_TOP
==> /u01/app/R12apps/fs_ne/EBSapps/patch
cd $PATCH_TOP
adop phase=apply patches=33600809,34668508,34669333,34681299,35280947 merge=yes
SQL> exec ad_zd.set_edition(‘PATCH’);
==> PL/SQL procedure successfully completed.
SQL> select BUG_NUMBER,STATUS,APPLIED_FILE_SYSTEM_BASE,to_char(START_DATE,’dd-mon-yyyy HH24:MI’) START_DATE,to_char(END_DATE,’dd-mon-yyyy HH24:MI’) END_DATE from AD_ADOP_SESSION_PATCHES where BUG_NUMBER in (‘33600809′,’34668508′,’34669333′,’34681299′,’35280947’);
Apply R12.TXK.C.Delta.14 & TXK critical patches at the same time :
=============================================================
echo $FILE_EDITION ==> RUN
echo $PATCH_TOP
==> /u01/app/R12apps/fs_ne/EBSapps/patch
cd $PATCH_TOP
adop phase=apply patches=33602997,34654260 merge=yes
SQL> exec ad_zd.set_edition(‘PATCH’);
==> PL/SQL procedure successfully completed.
SQL> select BUG_NUMBER,STATUS,APPLIED_FILE_SYSTEM_BASE,to_char(START_DATE,’dd-mon-yyyy HH24:MI’) START_DATE,to_char(END_DATE,’dd-mon-yyyy HH24:MI’) END_DATE from AD_ADOP_SESSION_PATCHES where BUG_NUMBER in (‘33602997′,’34654260’);
After successfully applying all the above patches the following will be the versions:
===============================================================================
select abbreviation, name, codelevel from ad_trackable_entities where abbreviation in( ‘ad’,’txk’,’atg_pf’,’pay’,’okc’,’hz’) order by abbreviation;
ABBREVIATI NAME CODELEVEL
———- ————————————————– ——————–
ad Applications DBA C.14
atg_pf Oracle Applications Technology Family C.9
hz Oracle Trading Community C.5
okc Oracle Contracts C.5
pay Oracle Payroll C.7
txk Oracle Applications Technology Stack C.14
*********************** END OF AD & TXK DELTA 14 PATCHES ***********************
******************* START OF CPU PATCH FOR JULY 2023 – PATCH 35385938 *******************
Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (July 2023) (Doc ID 2953580.1)
================================================================================
Download Patch 35583866 and follow the instructions in the patch Readme.txt file to run ECPUC.
Run ECPUC
===========
echo $FILE_EDITION ==> RUN
cd $PATCH_TOP/ECPUC
sqlplus APPS/*******
SQL> @ECPUC.sql
==> Apply all recommended patches listed in ECPUC.lst
1) PATCH 35385938 : ORACLE APPLICATIONS RELEASE 12.2: CPU PATCH FOR JUL 2023
=======================================================================
Prerequisite Our Environment version
————– —————————
12.2.3 ==> 12.2.5
R12.AD.C.delta.13 ==> R12.AD.C.delta.14
R12.TXK.C.delta.13 ==> R12.TXK.C.delta.14
Run “adgrants.sql” as oracle user
———————————-
Run the adgrants.sql script as a user that can connect as SYSDBA to grant privileges to selected SYS objects and create PL/SQL profiler objects.
Copy the adgrants.sql script from patch directory (120.67.12020000.56) or from $APPL_TOP/admin (120.67.12020000.69) which ever is higher version to the database tier server (Here copy adgrants.sql script from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin/ )
$ cp $APPL_TOP/admin/adgrants.sql $ORACLE_HOME/appsutil/admin/
source $ORACLE_HOME/<CDB_NAME>_<HOSTNAME>.env
export ORACLE_PDB_SID=<EBS PDB Name>
cd $ORACLE_HOME/appsutil/admin/
sqlplus /nolog
SQL> @adgrants.sql APPS
Apply PATCH 35385938 CPU PATCH FOR JULY 2023
———————————————
echo $PATCH_TOP
==> /u01/app/R12apps/fs_ne/EBSapps/patch
cd $PATCH_TOP
adop phase=apply patches=35385938
Update Database Tier to Latest AutoConfig Code.
————————————————
Apps Tier : Run System
————————-
echo $FILE_EDITION ==> RUN
cd $INST_TOP/admin/scripts/ ; sh adautocfg.sh
perl $AD_TOP/bin/admkappsutil.pl
file created = $INST_TOP/admin/out/appsutil.zip
DB Tier
——–
cd $ORACLE_HOME ;
cp $INST_TOP/admin/out/appsutil.zip . ;
unzip -o appsutil.zip
cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME ;
sh adautocfg.sh
Additional patches required for this JULY 2023 EBS CPU (Recommended by ECPUC.lst)
———————————————————————————–
echo $FILE_EDITION ==> RUN
echo $PATCH_TOP
==> /u01/app/R12apps/fs_ne/EBSapps/patch
cd $PATCH_TOP
adop phase=apply patches=35181823
adop phase=apply patches=33207251
adop phase=apply patches=32980025
adop phase=apply patches=33286000
adop phase=apply patches=34212478
adop phase=apply patches=34556525
adop phase=apply patches=34744189
adop phase=apply patches=35355008
adop phase=apply patches=34291981
adop phase=apply patches=33625264
adop phase=apply patches=25229413
adop phase=apply patches=32004048
adop phase=apply patches=32636493
(OR)
adop phase=apply patches=35181823,33207251,32980025,33286000,34212478,34556525,34744189,35355008,34291981,33625264,25229413,32004048,32636493
****************** END OF CPU PATCH FOR JULY 2023 – PATCH 35385938 ******************
Complete Patch Cycle
=======================
echo $FILE_EDITION ==> RUN
adop phase=finalize
adop phase=cutover
Start with new Run edition Session
. <EBS_ROOT>/EBSapps.env run
echo $FILE_EDITION ==> RUN
adop phase=cleanup
adop -status -detail
Update Database Tier to Latest AutoConfig Code.
================================================
Apps Tier : Run System
————————-
echo $FILE_EDITION ==> RUN
cd $INST_TOP/admin/scripts/ ; sh adautocfg.sh
perl $AD_TOP/bin/admkappsutil.pl
file created = $INST_TOP/admin/out/appsutil.zip
DB Tier
——–
cd $ORACLE_HOME ;
cp $INST_TOP/admin/out/appsutil.zip . ;
unzip -o appsutil.zip
cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME ;
sh adautocfg.sh
Compile Invalids
====================
select count(*) from dba_objects where status = ‘INVALID’;
@?/rdbms/admin/utlrp.sql
select count(*) from dba_objects where status = ‘INVALID’;
FSCLONE Steps
===============
chmod -R 755 to 10.1.2 ($ORACLE_HOME) on Patch F/S not in Run F/S
echo $FILE_EDITION ==> RUN
adop phase=fs_clone
*************************** END ***************************
Recent Posts
