My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.