My Oracle Support Banner

PRODUCT_ALT Information Missing on W_PRODUCT_D (Doc ID 2959165.1)

Last updated on JULY 17, 2023

Applies to:

Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Oracle Retail Science Platform Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Goal

LOAD_DIM_INITIAL_ADHOC was run with the following jobs enabled:
COPY_SI_PRODUCT_ALT_JOB
COPY_SI_ORGANIZATION_ALT_JOB
STG_SI_PRODUCT_ALT_JOB
STG_SI_ORGANIZATION_ALT_JOB
SI_W_PRODUCT_FLEX_DS_JOB
SI_W_ORGANIZATION_FLEX_DS_JOB
W_PRODUCT_FLEX_D_JOB
W_ORGANIZATION_FLEX_D_JOB

Then LOAD_PDS_DIMENSION_PROCESS_ADHOC was run to send the data to PDS.

The PRODUCT_ALT data is loaded correctly into W_PRODUCT_ALT_DTS and W_PRODUCT_FLEX_D. However, it is not being loaded into the W_PDS_PRODUCT_D table. This only happens for PRODUCT_ALT; ORGANIZATION_ALT was loaded fine. Why?

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!

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