My Oracle Support Banner

RTLOG Totals With Negative Value Is Loaded With Positive Value In ReSA Tables (Doc ID 2307007.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Retail Sales Audit - Version 16.0 and later
Information in this document applies to any platform.


When loading a RTLOG (Retail Transaction log) into RESA (Retail Sales Audit system), the RTLOG containing totals with Negative value is loaded as positive value in RESA tables.

Steps to reproduce :

  1. Generate a RTLOG with negative total declared.
  2. Load the file into ReSA.
  3. Generate Store day and run the saimptlogi batch.
  4. Verify SA_TRAN_HEAD table,  the value is loaded as positive instead of a negative value.




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.