We are pleased to announce the availability of the latest updates for the Applications DBA (AD) and Technology Stack (TXK) components for Oracle E-Business Suite Release 12.2. This AD-TXK Delta 14 release includes new features, plus performance and stability fixes.
We strongly recommend that you 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)
Refer to the following for the latest updates and instructions for applying the latest AD and TXK updates:
- Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (MOS Note 1617461.1)
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:
- AD-TXK Delta 13: New Feature Highlight
- Oracle E-Business Suite Release 12.2 System Schema Migration (MOS Note 2755875.1)
- FAQ: Oracle E-Business Suite Release 12.2 System Schema Migration (MOS Note 2758999.1)
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:
-
Managing Database Privileges in Oracle E-Business Suite Release 12.2 (Running adgrants.sql) (MOS Note 2758993.1)
References
- Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.14 and R12.TXK.C.Delta.14 (MOS Note 2857317.1)
- Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (MOS Note 1617461.1)
- Oracle E-Business Suite Release 12.2 System Schema Migration (MOS Note 2755875.1)
- FAQ: Oracle E-Business Suite Release 12.2 System Schema Migration (MOS Note 2758999.1)