AD-TXK Delta 13: New Feature Highlight – Part III

April 7, 2022 | 3 minute read
Elke Phelps
Product Management Director
Text Size 100%:

We recently announced the availability of AD-TXK Delta 13. This is part three in a series of blog articles to highlight the Oracle E-Business Suite (EBS) System Schema Migration, a key new feature of AD-TXK Delta 13 and Oracle E-Business Suite Release 12.2.11.

What are the Requirements to Complete the EBS System Schema Migration?

There are four requirements to complete the EBS System Schema Migration as follows:

  1. Apply AD-TXK Delta 13.
  2. Apply the EBS 12.2.11 Release Update Patch (RUP) or the EBS System Schema Migration Consolidated Patch.
  3. Update Your Custom Code with Mandatory Compliance Requirements.
  4. Apply the EBS System Schema Migration Completion Patch.

For more information, see the following:  Oracle E-Business Suite Release 12.2 System Schema Migration (MOS Note 2755875.1)

This blog article focuses on Requirement 1: Apply AD-TXK Delta 13. The remaining requirements to complete the EBS System Schema Migration will be described in detail in upcoming blog articles.

What are the Key Features of AD-TXK Delta 13?

The following are the key features introduced with AD-TXK Delta 13:

  • A new schema, EBS_SYSTEM, is created. Prior to the introduction of the EBS_SYSTEM schema, Oracle E-Business Suite installed application objects in the Oracle Database SYS and SYSTEM schemas. Migration to the EBS_SYSTEM schema removes the need for any EBS-owned objects to reside in the SYS and SYSTEM schemas.  
  • All EBS administration utilities (such as adop, adadmin) now prompt for the EBS_SYSTEM password.
  • AD and TXK code objects are moved from the SYS or SYSTEM schemas to EBS schemas (APPS, APPS_NE or EBS_SYSTEM) and all EBS code references to the moved code objects are updated accordingly.  
  • AD and TXK code has been updated to leverage public database APIs.
  • Database service names are now used for EBS application tier connections to the database.

How Do You Apply AD-TXK Delta 13?

Applying AD-TXK Delta 13 is similar to other AD and TXK RUPs. Use the instructions in the following My Oracle Support knowledge document to apply AD-TXK Delta 13:

Per the documentation, perform the following tasks prior to applying AD-TXK Delta 13:

  • Run the Online Patching Database Compliance Checker (ADZDDBCC.sql) to verify the health of your EBS database objects and configuration.
  • Download the patches and manually run adgrants.sql on the database tier which will:
    • Create the EBS_SYSTEM schema.
    • Grant the required privileges to the EBS_SYSTEM schema.
  • Manually unlock the EBS_SYSTEM account.
  • Manually set the EBS_SYSTEM password to match the SYSTEM password.

How Can You Learn More About the EBS System Schema Migration?

In addition to the upcoming series of blog articles on this topic, learn more about the EBS System Schema Migration by leveraging the following resources:

References

Related Articles

Elke Phelps

Product Management Director

Elke is a Product Manager in the Oracle E-Business Suite Applications Technology Group.  She joined Oracle in 2011 after having been an Oracle customer and Oracle Technologist (Oracle Database Administrator, Oracle Applications DBA, Technical Architect and Technical Manager of an Oracle Applications DBA Team) since 1993.  As part of the Oracle E-Business Suite Applications Technology Product Management Team, her scope of responsibility includes security, database certifications and advanced architectures for on-premises and Oracle Cloud deployments.  She is a frequent contributor and editor of the Oracle E-Business Suite Technology Blog.

Elke is the lead author of the Oracle Applications DBA Field Guide (Apress 2006) and Oracle R12 Applications DBA Field Guide (Coqui Tech and Press 2010).  Elke is also the founder of the Oracle Applications User Group (OAUG) E-Business Suite Applications Technology Special Interest Group (SIG) and served as President of the SIG from February 2005 - August 2011.  Elke has been a speaker at the Oracle OpenWorld and Collaborate conferences since 2004.  Prior to joining Oracle, Elke was designated an Oracle ACE (2007) and Oracle ACE Director (2009).  She received the OAUG Oracle Ambassador of the Year award in 2015.

Elke has a Computer Science Degree and a Masters of Business Administration from the University of Oklahoma.  In her spare time, Elke enjoys traveling especially to Europe, Puerto Rico and the amazing US National Parks.  Elke also enjoys hiking, antiquing, gardening and cooking. 

 


Previous Post

Firefox Browser ESR 91.x Certified with EBS 12.2 for Windows and MacOS

Elke Phelps | 2 min read

Next Post


AD-TXK Delta 13: New Feature Highlight – Part IV

Elke Phelps | 3 min read