Error While Performing RUA In RMS
(Doc ID 2890137.1)
Last updated on JANUARY 04, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
Error while performing RUA in RMS.
1. Create a PO ordering (e.g 6 units) of an item to a WH.
2. Receive the PO for 2 units
a. Shipment A is created
3. Receive again the PO for 4 units (a diff ASN and a diff container/carton ID passed in)
a. Shipment B is created
4. IM is done manually for testing:
a. Update the INVC_MATCH_STATUS to ‘M’ and populate the INVC_MATCH_DATE in the SHIPMENT table.
update shipment set invc_match_status = ‘M’, invc_match_date = get_vdate() where order_no = <order_no>;
b. Update the INVC_MATCH_STATUS to ‘M’ and QTY_MATCHED (value would equal the QTY_RECEIVED field) in the SHIPSKU table.
update shipsku set qty_matched = 4, -- equal to QTY_RECEIVED for each shipment/item record invc_match_status = ‘M’ where shipment = ;
5. Receive the PO for the 3rd time for another 4 units (same ASN from Step 3 but diff container/carton ID).
a. Shipment C is created.
6. Perform the adjustment:
a. In the UI, go to Inventory -> shipments and Receipts ->Shipments.
b. In the Shipment Search, search for shipments using the Order Number. Note that 2 shipments are displayed
c. Highlight Shipment B from Step 3 and then click the Adjust Receipt screen.
d. Enter 0 in the Corrected field for the record that has no ‘matched’ value and then click the Save button. Error is displayed.
Invalid input parameter l_loc, passed as NULL, expected NOT_NULL .
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 |
Cause |
Solution |
References |