My Oracle Support Banner

After Applying Bug 31226346 All Lines Go to Error with "Quantity Shipped is Zero" or "Error Due to Associated Header Being in Error " on the Advanced Shipping Receipt if Only One Line has a Zero Value in QTY_SHIPPED_CONV Field (Doc ID 2816029.1)

Last updated on AUGUST 01, 2024

Applies to:

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

Symptoms

After Applying Bug 31226346 All Lines Go to Error with "Quantity Shipped is Zero" on the Advanced Shipping Receipt if Only One Line has a Zero Value in QTY_SHIPPED_CONV Field.  If you then try to run PO_RECVLOAD for the Advanced Shipping Receipt, no lines are loaded (Even ones with non-zero value)

Error Received on Line with a zero value:


Steps to create the issue

(Note: Steps assume that all of the Integration Broker Set up is done.)

1) Go to Suppliers -> Supplier Information -> Add/Update -> Add/Update Supplier (click on Correct History) -> Locations tab -> Procurement -> Additional Procurement Options and check on Advanced Shipment Receipt

2) Go to Purchasing -> Purchase Orders -> Add/Update POs and create a PO with a few lines. Budget check if necessary and approve. Dispatch PO

3) Go to PeopleTools -> Integration Broker -> Service Utilities -> Handler Tester and load the Advanced Shipping Receipt. (Make sure one line in the ASR has 0 for QTY_SHIPPED_CONV field)

4) Go to Purchasing -> Receipts -> Review Receipt Information > Advanced Shipment Receipts note that all lines are in error.

5) Click on line with 0 value - get error:  Quantity Shipped is Zero (10301, 106)

6) Click on any other line that has a non-zero value get error: Error Due to associated header being in error. (10301, 87)

7) Go to Purchasing -> Receipts -> Load Receipts and load receipts.  Job goes to success, but if you search  Purchasing -> Receipts -> Add/Update Receipts the receipt does not exist.

See replication steps here.

 

Changes

 NOTE: Before Bug 31226346 was applied to the system if there was a Zero value in the QTY_SHIPPED_CONV all rows (even the row with the zero value) would still create a receipt.  Information about this bug can be found in Purchase Order Receipt Load Process (PO_RECVLOAD) Creating Receipts Successfully for blank quantity Advanced Shipment Notice (ASN) (Document 2718940.1)

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.