XSTORE RTLOG Imported Values, For Bank Deposit Transactions, Do Not Populate VALUE Column from SA_TRAN_HEAD Table

(Doc ID 2334131.1)

Last updated on DECEMBER 06, 2017

Applies to:

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

Symptoms

When importing RTLOG files with bank deposit transactions from XSTORE, the VALUE column from SA_TRAN_HEAD table is populated with 0(zero) value.
The VALUE column from SA_TRAN_HEAD table should be populated with the value from imported RTLOG file.



Steps to Reproduce:

  1.  Import RTLOG file with saimptlogi batch having a transaction with types: TRAN_TYPE = 'OTHER', SUB_TRAN_TYPE ='BANK' and value filled in.
  2.  Notice that transaction is imported successfully without entries in SA_ERROR table.
  3.  Notice that the VALUE column from SA_TRAN_HEAD table is populated with zero.

 

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