We recently announced the availability of AD-TXK Delta 13. This is part six 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 4:  Apply the EBS System Schema Migration Completion Patch.

What is the EBS System Schema Migration Completion Patch?

The EBS Schema Migration Completion Patch (Patch 32573930) also referred to simply as the Completion Patch, is the fourth and last major requirement to complete the EBS System Schema Migration.

The Completion Patch will drop all EBS objects that are in the SYSTEM schema. As a final post-apply step for the patch, you will be required to run a script to drop AD objects from the SYS schema and revoke privileges that are no longer required, as EBS objects have been moved from the SYS and SYSTEM schemas to appropriate EBS schemas.

How Do You Apply the EBS System Schema Migration Completion Patch?

Applying the EBS System Schema Migration Completion Patch (Patch 31817501) ) is similar to other EBS 12.2 patches. Use the instructions in the following My Oracle Support knowledge document to apply the EBS System Schema Migration Completion Patch:

What are the Impacts to Your Custom Code When Applying the EBS System Schema Migration Completion Patch?

You must update your custom code with mandatory compliance requirements prior to applying the EBS System Schema Completion Patch (Patch 32573930). Failure to update custom code with mandatory compliance requirements prior to applying the EBS System Schema Completion Patch (Patch 32573930) will result in invalid custom database objects.

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

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

References

Related Articles