My Oracle Support Banner

AIP-Online: 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.


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


"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
ERROR at line 1:
ORA-20001: ORA-02292: integrity constraint (AIP.FK_PAD) violated -
record found returned by AIP_PURGE.EXECUTE_PURGE while purging commodity
ORA-06512: at line 8"





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.