My Oracle Support Banner

CONTENTS_ITEM_EXIST Error During Item Deletion For Bottle Deposit Items (Doc ID 2383021.1)

Last updated on FEBRUARY 27, 2019

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".


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.