My Oracle Support Banner

RDE_EXTRACT_RESA_SALE_FACT_GCNLDSDE_JOB - QTY AND Amounts (Doc ID 3008268.1)

Last updated on MARCH 04, 2024

Applies to:

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

Symptoms

When RDE is in CFS, the following columns in the W_RTL_GCN_TRX_LC_DY_FS table are incorrect as they are divided by 10000 after running the RDE_EXTRACT_RESA_SALE_FACT_GCNLDSDE_JOB job.

- GCN_SLS_QTY (should use XTERN_RDWT.TOT_SALES_QUANTITY as is)
- GCN_SLS_AMT_LCL (should use XTERN_RDWT.TOT_SALES_QUANTITY as is)
- GCN_RET_QTY (should use XTERN_RDWT.TOT_TRANSACTION_VAL as is)
- GCN_RET_AMT_LCL(should use XTERN_RDWT.TOT_TRANSACTION_VAL as is)

Cause

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
Symptoms
Cause
Solution
References


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