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 laterInformation in this document applies to any platform.
Symptoms
On : 23.1 version, ReSA - Others
ACTUAL BEHAVIOR
---------------
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.
STEPS
-----------------------
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.
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 |