AIP 14.1.2: Error in Applying the Patch if CROSS_DOCK_SCHEDULE Is Populated (Doc ID 2113001.1)

Last updated on MARCH 09, 2016

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

When patching from Advance Inventory Planning 14.1 to 14.1.2, if the CROSS_DOCK_SCHEDULE is populated, then the script 0370_s20995340_cross_dock_schedule.sql fails when trying to insert the data back into the modified table. This is table definition now includes a new column named CHUNK_ID which is not null and has no default value, but the insert does not populate the column. Thus, the insert fails.

The 0370_s20995340_cross_dock_schedule.sql script performs the following actions:

1. Rename the existing CROSS_DOCK_SCHEDULE table in order to preserve the data.
2. Create a new CROSS_DOCK_SCHEDULE table with an additional column named CHUNK_ID. This new column is designated as NOT NULL and does not have a default value.
3. Insert the exiting records from the table in Step 1 back to the new table.

The bug is that the insert statement in Step 3 does not populate the new column, which is required (or the table itself is not defined to have a default value for the new column).

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