My Oracle Support Banner

RI Reclass Flow (Doc ID 3000578.1)

Last updated on JANUARY 29, 2024

Applies to:

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

Goal

On : 16.0 version, ODI-RMS-ReSA Extracts

Reclass Flow clarification?

When RMS reclassifies an item, it generates two tran_codes, 34 and 36, one for the new hierarchy and the other for the old hierarchy.

In RI, the reclassified item passes through SDE_RETAILPRODUCTRECLASSTEMP. The new reclassified item is processed by PLP_RETAILFACTOPENFACT, which is responsible for inserting new records into the fact tables and G.
Subsequently, PLP_RETAILFACTOPENFACT updates/deletes old reclassified items from the fact tables and G.

However, since RMS generated a tran_code for the old reclassified item, it is inserted again into the fact and G tables by SIL_RETAILINVPOSITIONFACT, even though PLP_RETAILFACTOPENFACT deleted the old item.?
 

Solution

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
Goal
Solution


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