My Oracle Support Banner

AIF/RDE Not Handling Item Deletes Correctly (Doc ID 2954404.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 19.0 and later
Information in this document applies to any platform.


AIF/RDE are not handling item deletes correctly.

This issue can happen under the following scenario..

1. RMS has a bug which allows an item to be duplicated when it is created as MANL item_number_type with spaces at the end of the item number.
2. When these items are purged in RMS and RDE extracts full foundation data, the correct item comes in the PRODUCT file and Delete comes as part of W_RTL_ITEM_DEL_TMP.dat. RA does not distinguish between both items as W_RTL_ITEM_DEL_TMP does not contain item_type.
3. This causing DIM_PROD_VALIDATOR_JOB to abort with PROD_R5 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.