My Oracle Support Banner

ORASE: How to Correct Historic Sales Transaction Values (Doc ID 2498070.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Retail Advanced Science Engine Foundation Cloud Service - Version 17.0 and later
Oracle Retail Science Platform Cloud Service - Version 17.0 and later
Oracle Retail Advance Science Cloud Service Suite - Version 17.0 and later
Information in this document applies to any platform.


Is it possible to adjust profit values from historical sales data which have already been processed?

For example, an issue was identified on the profit values (SLS_PROFIT_AMT_LCL) of ALL sales transaction files (W_RTL_SLS_TRX_IT_LC_DY_FS.dat) which results in the UI showing incorrect values in all profit related indicators such as:

Avg Profit from If Items
Avg Profit from Affinity Items
Avg Tot Sales Profit Amt
Avg Profit per Basket from IF Items
Avg Profit per Basket from Affinity Item
Avg Profit
Target Profit


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.