When a PO Is Received by Multiple Users, SIM Publishes Multiple ReceiptCre Messages With New ASN Numbers That Do Not Have Matching Shipments in RMS (Doc ID 2164633.1)

Last updated on JULY 29, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 13.1.9 and later
Information in this document applies to any platform.

Symptoms

In the Store Inventory Management (SIM) application, we find that a Purchase Order (PO) can be received by multiple users at the same time. This causes SIM to generate multiple ReceiptCre messages to Retail Merchandising System (RMS). The shipment details in RMS get updated with SIM generated ASN numbers. However, the last received ASN does not have any invoice matched to it, causing major issues with vendor payments.


Steps to Recreate:

  1. In RMS, create a PO with a vendor ASN attached.
  2. In SIM, log into the store as user 1.
  3. Open the PO and do not do anything.
  4. Log into the same store in SIM as user 2.
  5. Open the same PO.  Note that there are no messages to user 2, indicating that user 1 already has a lock on the PO.
  6. Complete the receipt and confirm.
  7. Now, go back to the session of user 1.  Receive different quantities than in step 6 and confirm.
  8. Find that SIM publishes two "ReceiptCre" messages to RMS.
  9. In RMS find that the quantity received for the PO is updated as the quantity from step 7.
  10. In RMS, find that the shipment record is updated with both receipts and the receipt from step 7 has a new SIM generated ID that does not match any existing invoices in Retail Inventory Matching (ReIM) application.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms