All ASR Lines Go To Error If Only One Line Has A Zero Value In The QTY_SHIPPED_CONV Field (Doc ID 2956803.1)

Last updated on JULY 11, 2023

Applies to:

Symptoms

All ASR lines go to error when the quantity shipped is zero or in error due to the associated header being in a status of error on the Advance Shipping Receipt page


The issue can be reproduced at will with the following steps:
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.

Issue can also be replicated with the below steps:

1. Navigate to Service Operations page. (PeopleTools ->Integration Broker ->Integration Setup ->Service Operation Definitions)
2. Search for ADVANCED_SHIPPING_RECEIPT
3. Make sure that the Active flag is enabled.
4. Click on the Handlers tab.
5. Confirm that the Advanced Shipping Receipt is updated and Active
6. Save the page.
7. Navigate to Supplier Information Page. (Suppliers ->Supplier Information->Add/Update Supplier)
8. Search for Supplier SCM0000001
9. Click on the Locations tab.
10. Click on Procurement link.
11. Expand the Additional Procurement Options
12. Select the Advanced Shipment Receipt checkbox.
13. Save the Page
14. Navigate to Add/Update POs ( Purchasing->Purchase Orders->Add/Update POs)
15. Add a new PO for our Supplier
16. Save the PO
17. Click on the Dispatch button to Dispatch PO
18. Navigate to the Handler Tester Search Page (PeopleTools->Integration Broker->Service Utilities->Test Service Operations)
19. Search for Service Operation of ADVANCED_SHIPPING_RECEIPT
20. Search results select Advanced Shipping Receipt, Version_2
21. Choose Handler Type as On Notify, Handler Name as AdvancedShippingReceipt
22. Enter Carrier ID, Seq Number, Inv Item Id, UOM, Schedule Number, Line number, Qty....
23. Click OK and Save the page.
24. Navigate to the Advanced Shipment Receipts Page. (Purchasing->Receipts->Review Receipts Information->Advanced Shipment Receipts)
25. Search four our receipt using the Carrier ID.
26. Make note of the EIP Control ID
27. Run the Receipt Load Process. (Purchasing->Receipts->Load Receipts)
28. Navigate to the Advanced Shipment Receipt Page (Purchasing->Receipts->Review Receipts Information->Advanced Shipment Receipts)
29. Search with the EIP control ID and ASR Processing Status of Error
30. We get No matching values were found which is not correct.
31. Data should display with a status of Error since the process did go to Error.

Changes

Cause

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