E1: ESU : Enhancement Request - Simplify Process to Add New Columns to Tables (Doc ID 2275748.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms

When any ESU delivers new specs for tables, there are usually associated special instructions which requires to generate the indexes or run a table conversion program shipped along with the ESU. If an existing table has been modified to add 1 or more columns, then we should have a mechanism to add these new columns in a very simple way like running a SQL Query instead of running a table conversion for the same. It could be on the same lines of a *Alter program that is used in the newer upgrade process. Alternatively we could have a new button in OMW or a separate program that can add the extra columns. This enhancement would ideally simplify the execution of special instructions for tables.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms