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

Last updated on SEPTEMBER 14, 2017

Applies to:

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

Symptoms

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.

Changes

 

Cause

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 hundreds of Community platforms