My Oracle Support Banner

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.

Symptoms

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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.