The Quantity Available To Allocate Is Not Correct for Purchase Order (PO) Based Allocations (Doc ID 558116.1)

Last updated on NOVEMBER 10, 2016

Applies to:

Oracle Retail Allocation - Version 12.0.6 and later
Information in this document applies to any platform.
ItemSqlGeneratorSearchPoDefault.java
ItemSqlGeneratorSearchPoNumbers.java
ItemSqlGeneratorSearchPoSource.java
Checked for relevance May-2013


Symptoms

The quantity available to allocate is not showing the correct quantity after a receipt has been done against the Purchase Order (PO) allocation.

Steps To Reproduce:

  1. Create and approve a PO to the warehouse with quantity 1100
  2. Allocate 500 quantity to a store
  3. Approve the allocation
  4. Login to Retail Warehouse Management System (RWMS) and receive 50 units against the 500 that are allocated
  5. Verify Retail Merchandising System (RMS) was correctly updated with the receipt
  6. Login to Allocations and click on search for items to allocate.
  7. Enter the PO number and notice the quantity available to allocate.
  8. The Allocations screen is showing total order quantity - (total allocated qty + total received quantity) as the quantity available to allocate.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms