ReSA Import Batch Updates Inocrrect Record If Same ExternalID Is Used For 2 Different Sales (Doc ID 2955844.1)

Last updated on JUNE 16, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
When processing the SIMT file from RESA via the RetailSalesAuditImport batch job, incorrect transaction records are being altered and item SOH updated when external ID is same across 2 different business dates.

EXPECTED BEHAVIOR
-----------------------
Expect that SIOCS considers external ID in combination with other data to keep uniqueness based on TransactionID and BusinessDate.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Using Soap Client, Integrate the POS transactions to SIOCS
2. Check POS_TRANSACTION table to ensure both transactions have been processed
3. Check STORE_ITEM_STOCK table to ensure SOH has reduced by 2 and 1 respectively for each sale transaction.
4. Check STORE_ITEM_STOCK_HISTORY table and take a snapshot of the transactions.
5. Load the SIMT_TEST.dat file using EICS FTS/Imports
6. Run the RetailSalesAuditImport batch job
7. Note the changes to the transactions in the following tables. Only the transaction from March 8th should be altered and not the one from March 9th.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.