Transaction Net Sales Value Is Shown Already Rounded In RMICS -ReSA Side Change Check?
(Doc ID 2977786.1)
Last updated on OCTOBER 05, 2023
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.
On : 23.1 version, ReSA - Others
Transaction Net Sales Value is shown already rounded in RMICS- from ReSA .
Some transactions are being rounded on the extract to RMICS from ReSA.
The SA_EXPDW_RDWT_HEAD has the values rounded and without the decimal places as displayed in ReSA.
The issue can be reproduced at will with the following steps:
1. Create a sale transaction in ReSA with decimal places.
2. Run the ReSA jobs to make this transaction is error free and ready to be send to Retail Insights.
3. Run saexport_sales_to_dw to export the data directly to SA_EXPDW_RDWT_* tables.
4. Notice that SA_EXPDW_RDWT_HEAD table had all values are rounding without decimal values.
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