My Oracle Support Banner

Item Showing Unreceived PO Qty In The Item/Product Availability Page For No Open POs After Applying Bug 34254318 (Doc ID 2938304.1)

Last updated on APRIL 26, 2023

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Have an issue being reported for items showing unreceived PO Qty in the Item/Product Availability Page but there are no POs. On analysis, we found that when the users were adjusting the putaway qty, the system creates a negative qty putaway in the transactions table and the item shows unreceived PO Qty in the Item/Product Availability page. But instead of showing the new open qty, it shows the requested PO qty. So, if I have received 5 qty and I adjust it to 2 i.e. now I have 3 qty as Open, instead of showing 3 in the Item/Product Availability Page, it shows 5. When I receive the 3 Open Qty, the Item/Product Availability page still shows 2 unreceived PO qty though there is no open Qty in the PO.

The issue can be reproduced at will with the following steps:
1. Create a PO. Make sure it has an IN Unit and Receiving Required (Purchasing-->Purchase Orders--Add/Update POs)
2. Dispatch the PO
3. Navigate to Item/Product Availability-- Shows Supply Qty s the PO is not received (Inventory-->Manage Inventory-->Review Inventory Balance Info-->Item or Product Availability)
4. Navigate to Add/Update Receipt-- Receive the PO (Purchasing-->Receipts-->Add/Update Receipts)
5. Run Process Receipts to complete putaway of the item. (Purchasing-->Receipts-->Process Receipts)
6. Review Transaction History shows our putaway (Inventory-->Manage Inventory-->Analyze Inventory-->Review Transaction History)
7. Query RECV_LN_DISTRIB table. The RECV_DS_STATUS is set to M
8. Navigate to Item/Product Availability-- Now rows appear. (Inventory-->Manage Inventory-->Review Inventory Balance Info-->Item or Product Availability)
9. Add/Update Receipt page. Bring up the receipt. Receipt Qty is a read only field. We cannot change this field. (Purchasing-->Receipts-->Add/Update Receipts)
10. Click on the INV Status field which is MOVED. Change the Quantity here to 4 and press OK. Receipt Qty is now an Editable field
11. Click Save
12. Run Process Receipts (RECV_01) (Purchasing-->Receipts-->Process Receipts)
13. Review Transaction History--Now has a 020 Putaway row for a quantity of negative 6  (Inventory-->Manage Inventory-->Analyze Inventory-->Review Transaction History)
14. Item/Product Availability- Though the available qty for receiving again is 6, the Item/Product Availability page shows Supply Qty as 10. If I receive 6 qty, it will still show 4. The PO is fully received, but the Item/Product Availability page shows 4 qty. (Inventory-->Manage Inventory-->Review Inventory Balance Info-->Item or Product Availability)


 

Changes

 BUG 34254318-- ITEM SHOWING UNRECEIVED PO QTY IN THE ITEM/PRODUCT AVAILABILITY FOR NO OPEN POITEM SHOWING UNRECEIVED PO QTY IN THE ITEM/PRODUCT AVAILABILITY FOR NO OPEN PO ITEM SHOWING UNRECEIVED PO QTY IN THE ITEM/PRODUCT AVAILABILITY FOR NO OPEN PO

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
Changes
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.