My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.