My Oracle Support Banner

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 later
Information in this document applies to any platform.


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 .


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

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