My Oracle Support Banner

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

Last updated on SEPTEMBER 05, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


Note: This only applies to Applications Release 9.2

The 9.2 Planner Update containing Bug 28891148, and Change Assistant version, 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 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:



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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
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.