My Oracle Support Banner

SKUP (Style-Color) ID In RSE Table And PDS Tables Are Different (Doc ID 3014141.1)

Last updated on APRIL 02, 2024

Applies to:

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


On : 24.1 version, Integration

Why is that SKUP (Style-Color) ID in RSE table and PDS tables are different ?

We have loaded the dimension data to RAP (RI, AIF and PDS) using RDE integrations where MFCS is the source of data. However, we have noticed that there are some gaps between data set up in AIF and PDS.
The PROD_EXT_KEY in RSE_FCST_DEMAND_DTL_CAL_EXP table has "_-1" suffix. However in PDS the SKUP ID does not have "_-1"
W_PDS_PRODUCT_D table the ITEM_PARENT_DIFF does not have _-1 suffix. RP_G_SKUP_D table in PDS also does not have _-1 suffix.

This difference is creating issues in forecasting exchanges between systems. As we have already loaded all the dimension and history data, we need help identifying why both systems are out of sync.?


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.