My Oracle Support Banner

AIP-Online: Aip_purge.sh Fails Due to Integrity Constraint Violation (Doc ID 2341577.1)

Last updated on MAY 21, 2018

Applies to:

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

Symptoms

The aip_purge.sh job fails with an integrity constraint violation:

This is happening during purging for the commodity table.

The foreign key is referencing the table warehouse_unorderable.

The issue here is that warehouse unorderable is not part of the purge list of child tables that need to be processed before purging the parent commodity table.

The same issue should be found for the FK constraint WUE_COY_FK2 and the parent table stocking_point.

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.