Error ORA-02292 On Running DLYPRG Batch
(Doc ID 2713409.1)
Last updated on APRIL 14, 2021
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.
Getting below error when try to run dlyprg batch.
"ORA-02292: integrity constraint (RMS01.SPP_ISMC_FK) violated - child record found ORA-06512: at "RMS01.DELETE_ITEM_RECORDS_SQL"
Steps To Recreate:
1. Edit a non-pack item.
2. Go to More Action --> Simple Pack - Setup
3. Create a new simple pack
4. Once created, go to Actions --> Pack Item Details. Item screen for the pack is opened. Notice that a record is inserted into SIMPLE_PACK_TEMP table.
5. You can either close the browser at this point or return to the simple pack setup screen and close the browser. Notice record is left on SIMPLE_PACK_TEMP table.
6. Run DLYPRG batch.
7. Note the above error.
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