Store_item_stock Table Not Updated Correctly With ReSA Batch Processing
(Doc ID 2952218.1)
Last updated on MAY 30, 2023
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and laterInformation in this document applies to any platform.
Symptoms
In EICS if a new or missing item gets added in RESA for audit of a transaction, the STORE_ITEM_STOCK table records for the original items in the transaction is not updated correctly.
Steps To Reproduce:
1. Create a sale transaction (2 valid items + 1 invalid item)
2, Audit the transaction in ReSA and SIMT file will flow to EICS > FTS > Imports
3. Run ReSA import batch in EICS > Job Admin
4. STORE_ITEM_STOCK table does not get updated correctly after the modified ReSA sale updates the POS_TRANSACTION table.
Cause
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
Symptoms |
Cause |
Solution |
References |