Table Specification Rules
An update merges your table specifications from one release level to the next.
An update preserves these changes:
New tables
New indexes
An update replaces columns added or removed from existing JD Edwards EnterpriseOne tables. This includes changing field length, field type, and decimal position.
Instead of adding a new column to an existing JD Edwards EnterpriseOne table, use Oracle's JD Edwards EnterpriseOne Table Design Aid to create a second table that has the same key as the first table and add your modifications to the new table. Use system codes 55 -59. For custom tag files, be aware of data item changes in the JD Edwards EnterpriseOne data dictionary. From one release to the next, JD Edwards EnterpriseOne might change certain data item attributes, such as data item size, which can affect data integrity and how data is stored in the database.
For this reason, you might need to use Oracle's JD Edwards EnterpriseOne Table Conversion tool to convert the tag file data to the new release level. For base tables, the update process takes care of the data dictionary changes by upgrading the JD Edwards EnterpriseOne database to the new release level.
An update preserves custom indices over the custom tag files.