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:

"2534339 : 1514045661016 : AIP_PURGE[714] : INFORMATION : Deleted 0 records from
table commodity_cost
2534339 : 1514045675828 : AIP_PURGE[720] : ERROR : ORA-02292: integrity
constraint (AIP.FK_PAD) violated - child record found
DECLARE
*
ERROR at line 1:
ORA-20001: ORA-02292: integrity constraint (AIP.FK_PAD) violated -
child
record found returned by AIP_PURGE.EXECUTE_PURGE while purging commodity
ORA-06512: at line 8"

 

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.