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.
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:
- Import RTLOG file with saimptlogi batch having a transaction with types: TRAN_TYPE = 'OTHER', SUB_TRAN_TYPE ='BANK' and value filled in.
- Notice that transaction is imported successfully without entries in SA_ERROR table.
- 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