My Oracle Support Banner

TSF_EXPECTED_QTY and TSF_RESERVED_QTY Fields Are Not Cleared After Receiving the Allocation in RMS (Doc ID 2046293.1)

Last updated on MARCH 15, 2019

Applies to:

Oracle Retail Merchandising System - Version 14.0 to 14.0.3 [Release 14.0]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 14.0.x, we find that ITEM_LOC_SOH.TSF_EXPECTED_QTY and TSF_RESERVED_QTY are not cleared after a purchase order (PO)/Allocation is closed.

Steps to Reproduce:

  1. Create a PO in approved status in RMS.
  2. Create an allocation on that PO in the Allocation application.
  3. Approve the allocation.
  4. On the RMS side, allocations are created in Approve status.
  5. ITEM_LOC_SOH table TSF_EXPECTED_QTY and TSF_RESERVED_QTY are updated.
  6. Now ship and receive the PO in RMS.
  7. Also ship and receive the allocation in RMS.
  8. Run DOCCLOSE.

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


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