AIP-Online: aip_purge.sh Script Fails with "column does not exist" on RELEASE_WAVE_ASSIGNMENT and RELEASE_WAVE_ASSIGNMENT_EXC
Last updated on JULY 24, 2017
Applies to:Oracle Retail Advanced Inventory Planning - Version 15.0.2 and later
Information in this document applies to any platform.
While executing the script aip_purge.sh on AIP-Online, it doesn't complete successfully due to error regarding a reference to a column "STORE_ID" from table "RELEASE_WAVE_ASSIGNMENT", and that column does not exist. Same issue exists with RELEASE_WAVE_ASSIGNMENT_EXC. The join should be updated to use destination_id and destination_type in WAVE tables.
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