My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.


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.