This AD-TXK Delta 14 release includes new features, plus performance and stability fixes for the Applications DBA (AD) and Technology Stack (TXK) components for Oracle E-Business Suite Release 12.2

New Feature:  Oracle E-Business Suite (EBS) System Schema Migration

With AD and TXK Delta 13 and later, EBS has implemented a set of structural changes that modernize the EBS database architecture. These changes introduce a new schema named EBS_SYSTEM, which is defined with a least privileges model that utilizes public database APIs. In addition, connections from the application tier to the database have been updated to utilize database service names.  For more information regarding the EBS System Schema Migration, see the following:

 

Enhancement:  Managing Database Privileges

With AD and TXK Delta 14, enhancements have been made to the process for managing database privileges and the adgrants.sql script.  The adgrants.sql script detects if the database connection is as EBS_SYSTEM or APPS.  When connected as APPS there is new functionality that verifies existing database privileges in an EBS database.  When connected as EBS_SYSTEM a privilege is granted only if it does not currently exist which eliminates the possibility of database locks and resource contention.  For more information, refer to the following:

 

Oracle strongly recommends that we apply these new AD and TXK updates at your earliest convenience in the same online patching cycle:

  • R12.AD.C.Delta.14 (Patch 33600809)
  • R12.TXK.C.Delta.14 (Patch 33602997)

 

Reference : Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

Download the below AD & TXK Delta 14 patches along with the AD & TXK Critical patches listed below and unzip them in $PATCH_TOP:

p33600809_R12.AD.C_R12_LINUX.zip

p33602997_R12.TXK.C_R12_GENERIC.zip

 

AD_Critical_Patches :

p34668508_R12.AD.C_R12_GENERIC.zip

p34669333_R12.AD.C_R12_LINUX.zip (BUNDLE PATCH ON TOP OF R12.AD.C.DELTA.14)

 

TXK_Critical_Patches :

p34708635_R12.TXK.C_R12_GENERIC.zip

p34654260_R12.TXK.C_R12_GENERIC.zip

 

Apply Required Database Patches:

AD-TXK Delta 14 requires a number of database bug fixes to install and operate correctly. With this requirement in mind, before you apply the AD and TXK Delta 14 RUPs you must run the EBS Technology Code level Checker (ETCC), using the command checkDBpatch.sh

The latest version of ETCC is always available via Patch 17537119. Running the latest version will perform the following two important steps:

Check that all required database patches have been applied. To identify the prerequisite database patches, you will need for applying the Delta 14 RUPs refer to :

Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes

 

Note: If you are a Linux customer and your database release is 19.14 or later, along with the patches required by ETCC you must also apply Patch 33525014.

The older release of this patch may conflict with 19.17.0 RU, it will be rolled back automatically. So we will have to download and apply the latest release of 33525014

After applying the RU patch, run DB-ETCC and make sure there are no pending DB patches.

 

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 :

$ . ./EBSapps.env run

$ adop phase=prepare

  • From a separate session, source the “patch edition file system environment file” :

$ . $PATCH_BASE/EBSapps/appl/APPSDCDEV_dcdev.env

 

  • 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 “Document 1594274.1: Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes”

 

  • 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)

$ scp $PATCH_TOP/34669333/admin/adgrants.sql oracle@dbnode:$ORACLE_HOME/appsutil/admin/

 

On the database tier server :

[oracle@dcdev ~]$ . ./DEVCDB_dcdev.env  <– CDB env

[oracle@dcdev ~]$ export ORACLE_PDB_SID=DCDEV

[oracle@dcdev ~]$ cd /u02/oracle/db_1/19c/appsutil/admin

$ sqlplus /nolog

SQL> @adgrants.sql APPS

 

[applmgr@dcdev bin]$ $ perl $PATCH_TOP/33600809/ad/bin/adValidateEbssystemSchema.pl

Enter the APPS password:

Enter the SYSTEM password:

Validating APPS credentials…validated successfully

Validating SYSTEM credentials…validated successfully

Validating EBS_SYSTEM user

ebssys codelevel = C.0

All required validations completed successfully

 

  • Apply R12.AD.C.Delta.14 & AD critical patches in one go :

. ./EBSapps.env run

$ adop phase=apply patches=33600809,<Your 1st critical AD patch>,<Your 2nd critical AD patch> merge=yes

$ adop phase=apply patches=33600809,34668508,34669333 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’);

 

BUG_NUMBER     STATUS   APPLIED_FILE_SYSTEM_BASE   START_DATE     END_DATE

————————- ———— ————————- ————————– ————————–

33600809                  Y              /u01/dev/fs2                                   13-jan-2023 20:17          13-jan-2023 20:20

34668508                  Y             /u01/dev/fs2                                    13-jan-2023 20:17          13-jan-2023 20:20

34669333                  Y             /u01/dev/fs2                                    13-jan-2023 20:17          13-jan-2023 20:20

 

 

  • Apply R12.TXK.C.Delta.14 & TXK critical patches:

$ adop phase=apply patches=33602997,<Your 1st critical TXK patch>,<Your 2nd critical TXK patch> merge=yes

 

 Note: Patch 34708635:R12.TXK.C is not applicable for either Oracle E-Business Suite Release 12.2.12 or R12.ATG_PF.C.Delta.11.

If we are planning to Upgrade to R12.2.12, we don’t have to apply this critical patch.

$ adop phase=apply patches=33602997,34654260 merge=yes

 

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’);

 

BUG_NUMBER          STATUS        APPLIED_FILE_SYSTEM_BASE       START_DATE                END_DATE

—————————- ——————– —————————— ————————– ————————–

33602997                     Y                    /u01/dev/fs2                            13-jan-2023 21:05          13-jan-2023 21:19

34654260                     Y                    /u01/dev/fs2                            13-jan-2023 21:05          13-jan-2023 21:19

Recent Posts

Start typing and press Enter to search