ORDPRG_JOB Is Failing With Integrity Constraint Violated
(Doc ID 2983442.1)
Last updated on OCTOBER 30, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 23.0 to 23.1 [Release 23.0 to 23.1]Information in this document applies to any platform.
Symptoms
Every day the ORDPRG_JOB is failing in POM stage due to the below error.
ordprg_1~20230522061904~process~ordhead~-2292~ORA-02292: integrity constraint (RMS01.FK_ORDER_NO) violated - child record found~DELETE - order_no=60048
REPL_PO_APPROVAL_ERRORS
The error for this PO in this table is "VEND_MINI_NOT_MET".
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! |
In this Document
Symptoms |
Cause |
Solution |
References |