Daily Purge Job Fails Because Integrity Constraint On Franchise Tables
(Doc ID 3034996.1)
Last updated on OCTOBER 01, 2024
Applies to:
Oracle Retail Merchandising System - Version 16.0.2 to 16.0.3 [Release 16.0]Information in this document applies to any platform.
Symptoms
On : 16.0.2 version, Other
When attempting to run dlyprg.pc
the following error occurs.
ERROR
-----------------------
ERROR: sql_lib.batch_msg O_err_code:-2292 O_table:ITEM_MASTER O_err_data:DELETE in package DEL_ITEM ITEM: 1111xxx
sql_lib.create_msg message:@0PACKAGE_ERROR@1ORA-02292: integrity constraint (RMSOWNER.WFS_IEM_FK) violated - child record found@2DEL_ITEM
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Produce records in WF_ORDER_DETAILS or WF_BILLING_SALES.
2. Add the same item should be inserted in daily_purge table.
3. Run Daily Purge (dlyprg) job.
4. It should fail with Integrity Constraint
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot purge items.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |