AIP-Online: aip_purge.sh Script Fails with "column does not exist" on RELEASE_WAVE_ASSIGNMENT and RELEASE_WAVE_ASSIGNMENT_EXC
(Doc ID 2284917.1)
Last updated on MARCH 05, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!