CONTENTS_ITEM_EXIST Error During Item Deletion For Bottle Deposit Items

(Doc ID 2383021.1)

Last updated on APRIL 09, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


The content and container item is deleted from the UI and it gets inserted into the daily_purge table as deletes with delete_order = 2 for both the items. When daily purge (dlyprg) is run it throws an error "CONTENTS_ITEM_EXIST" randomly.

Steps to recreate:

1. From RMS Delete Content item.
2. From RMS delete Container item.
3. Notice that daily_purge table having delete_order =2 for both the items.
4. Run dlyprg job.
5. Check daily_purge_error_log. This will have an error for Container item with "CONTENTS_ITEM_EXIST".




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms