My Oracle Support Banner

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 MARCH 02, 2019

Applies to:

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


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.



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.