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:

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

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