E1: ESU: *Alter In ESUs for Table Conversions (TCs) (Doc ID 2554489.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Purpose

Note: This only applies to Applications Release 9.2

The 9.2 Planner Update containing Bug 28891148, and Change Assistant version 4.0.1.0, introduced a change into the ESU process. It enables automatically running *ALTER in ESUs and ASUs. This replaces most of the manual TCs (Table Conversions) shipped with ESUs. This change will only be seen in ESUs built after August 1, 2019. There will still be some manual TCs in ESUs if the table change requires anything more than adding extra columns with blanks and zeroes.

With Change Assistant 4.0.1.3 and the Planner Update containing Bug 31368190 (DROPPED COLUMNS F06017 AND F053030 DURING ESU), you can choose whether to run the *ALTER when applying the ESU or not.
If you don’t run the *ALTERs with the ESU, you will need to run them manually after deploying the Update Package, using the Standalone TC Workbench (see below).

Note: For Tools Release 9.2.7x and later, when applying ESUs via the Web Client the process has changed. See the bottom of this document for more details.

Advantages for customers are:

• Less manual steps to run to deploy ESUs.
• Do not need multiple TCs for a single table that has changed multiple times in multiple ESUs. The *ALTER runs against the table in any state.
• *ALTER runs much faster than traditional table conversions, as it does not copy the data in the table.
• *ALTER is easier to troubleshoot and less prone to errors than individual Table Conversions (R89xxxx).

Instructions:

Before applying an ESU that includes a *ALTER:

1. Download and install the latest Planner ESU (and perform special instructions) on the Deployment Server that contains Bug 28891148.
2. Download the latest version of Change Assistant (or make sure it was automatically updated) on the Deployment Server.
3. Apply/Deploy an ESU using the ESU application (P96470) or Change Assistant.

Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.