My Oracle Support Banner

UPC Purge And Re-assignment (Doc ID 3013150.1)

Last updated on MARCH 28, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.


UPC Purge and re-assignment not working?

We have found that item is not removed from the rdw_delete_item table after creating the new item with same item number.
This is a valid business scenario (UPC purge and re-assignment )

Note : This is causing FATAL errors in AIF Batch

The issue can be reproduced at will with the following steps:
1. Delete a UPC (below tran level item)
2.  Run daily purge
3. Notice item deleted from RMS and appears in RDW_DELETE_ITEM
4. Add the UPC back to same or different item parent (SKU) Items added in item_master
5. Notice that Delete record still exists in RDW_DELETE_ITEM?


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.