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