My Oracle Support Banner

TSF_ALLOCATION.QUANTITY_RECEIVED column is not Updated When Allocations are Received and Confirmed (Doc ID 2285908.1)

Last updated on MARCH 02, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.


In Store Inventory Management (SIM) application, when a transfer shipment with an allocation attached, is received, the quantity received does not update the allocation correctly.

Steps to Recreate:

1. Create an allocation from a Warehouse to a Store for an item with some quantity (ex: 20).
2. Create a shipment in Warehouse Management System (WMS) and dispatch the transfer to SIM.
3. Query SIM database table TSF_ALLOCATION and note that the QUANTITY_RECEIVED column shows as "null" for this incoming allocation, created via SOCre message from Retail Merchandising System (RMS).
4. In SIM, receive the transfer and confirm.
5. Query TSF_DELV_LINE_ITEM, STORE_ITEM_STOCK and TSF_ALLOCATION database tables and note that all tables are updated with required details.
6. However find that TSF_ALLOCATION.QUANTITY_RECEIVED field is updated as 0 (Zero) from "null" in Step 3 above.




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.