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 JULY 24, 2017

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

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