AIP 14.1.2: Error in Applying the Patch if CROSS_DOCK_SCHEDULE Is Populated
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.
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).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms