My Oracle Support Banner

Problem in The SDE_RETAIL_SALESTRANSACTIONFACT Extraction Process. (Doc ID 2443170.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


When there is a variation in the AV_COST of the ITEM_LOC_SOH table, the RMA process inserts the difference that existed in AV_COST between the days the item was sold and canceled in ReSA, when should have inserted 0.

Steps To Recreate:

1. Run the query below:

2. Open the SDE_RETAIL_SALESTRANSACTIONFACT scenario and verify that the SLS_PROFIT_AMT_LCL field is generated from the AV_COST field found in the ITEM_LOC_SOH table, which is generated at run time.




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.