My Oracle Support Banner

AIP-Online: Aip_purge.sh Fails Due to Integrity Constraint Issue on PRE_ALLOCATION_DCRP Table (Doc ID 2392076.1)

Last updated on MAY 07, 2018

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

The aip_purge.sh job is failing with below integrity constraint violation error because of missing records in the PURGE_LIST table for PRE_ALLOCATION_DCRP table:

ERROR:

 

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.