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.
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:
"2534339 : 1514045661016 : AIP_PURGE : INFORMATION : Deleted 0 records from
2534339 : 1514045675828 : AIP_PURGE : 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!