My Oracle Support Banner

No Message Sent To RMS When SIM Approves RTV Via External RTV Request Parameter (Doc ID 2491335.1)

Last updated on NOVEMBER 01, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Oracle Retail Merchandising System - Version 16.0 and later
Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.


Retail Store Inventory Management (RSIM) does not send Return to Vendor (RTV) message back to Retail Merchandising System (RMS) when approved via external RTV requests parameter . When SIM “owns” RTV, RMS updates status=12 (In-Progress) and prevents RMS users from modifications. If an approved status RTV request in RMS is edited (for example to change a quantity, or to cancel the RTV) it will try to flow to SIM to provide SIM with the needed updates/cancellations via a MPS Staged Message. However, SIM prevents the induction of the MPS Staged Message coming from RMS because it says the return cannot be modified, even when the SIM status of the RTV Request is only in ‘Approved’ status.

The business expectation of SIM would be to send Message on Approval to RMS so RMS would update status=12 (In-Progress) and prevent RMS users from modifying RTV.

Steps to Reproduce:

Requirements: Set Auto-Except External Generated RTV Request = Yes

1. Navigate to MPS Work Type: Stop RTV Outbound – Verify if SIM sends message on Approval.
2. Log into RMS.
3. Navigate to Tasks > Inventory > Create Return To Vendor.
4. Input Supplier Site, Location (STORE), Store Number, and a Return Authorization value.
5. Click Ok and Return to Vendor tab is displayed.
6. Within Items, click the + icon to add an item.
7. Input an Item Number, Requested RTV quantity, Inventory Type: Overstock.
8. Click Ok. The item is added to the RTV request.
9. Click Approve and answer YES to the prompt “Do you want to approve this return?”
10. A pop up information box is displayed notifying, RTV Approved successfully. Click the OK button.
11. Click Save and Close.
12. Sign into SIM and change store to the RTV location.
13. Navigate to Shipping/Receiving > RTV.
14. Observe that the RTV request has correctly been Auto Approved, but take no actions to start a shipment.
15. Navigate back to the main SIM Login page by clicking BACK twice.
16. Navigate to MPS Staged Message\MPS Work Type and verify if SIM sent RTV message to RMS.

Error: No message sent to RMS
Note: If user manually approves quantity <> requested quantity, SIM sends RTV message to RMS and RMS updates and sets status = 12

17. Return to RMS.
18. Navigate to Tasks > Inventory > Manage Returns To Vendor.
19. Search for the RMS initiated RTV document which was approved in SIM.
20. With the RTV document highlighted, select Actions > Edit. The RTV details are displayed.
21. Within the Items section of the RTV details, select the RTV item and then select Actions > Edit.
22. In the Edit Items pop-up window, alter the requested quantity to another value and click Ok.
23. Click Save and Close.
24. Return to SIM and Navigate to Shipping/Receiving > RTV. Observe that the RTV is still in an Approved status.
25. Double-click on the RTV to view the item details and obvserve that the requested quantity has not been adjusted to match the new RMS edited quantity.
26. Click Back > Back > Back to return to the main SIM Login screen without altering the details of the approved status RTV request.
27. Navigate to Admin > Technical Maintenance > MPS Staged Messages.
28. Click on the Filter and set it to Family: RTVReq, In/Out: Inbound, Show Pending (checked), Show Retry (checked) and click Apply.
The RTV request document can be located within the Business ID column.
29. After the message has tried at least a few times to process on it’s own, double click on the line to show the Message Contents and Error Details.
30. The message from RMS is not processing into SIM because SIM states that the Vendor Return cannot be modified in a status of APPROVED.

Within RMS, attempt to Cancel the RTV Request and see it flow to SIM.

31. Return to RMS.
32. Navigate to Tasks > Inventory > Manage Returns to Vendor.
33. Search for the RTV Request.
34. With the RTV document selected in the search results, Select Actions > Edit. The RTV Details are displayed.
35. Click Cancel RTV.
36. Confirm with YES at the prompt, Do you want to cancel this order?
37. A message box is displayed confirming that the “RTV Cancelled successfully”. Click OK.
38. Click Save and Close. The RTV will show a status of cancelled in RMS.
39. Return to SIM and verify that the RTV request is still in Approved Status and that the details of the RTV request are unaltered from their original state prior to both the RMS quantity edit and the RMS RTV cancel.
40. Navigate back to Admin > Technical Maintenance > MPS Staged Messages and once again filter on the RTV REQ family of records.
41. Delete the original RTVReqDtlMod (the attempt to modify the RTV item quantity) MPS message as it will never process successfully.
42. Notice that there is a new RTVReqMod MPS staged message for the same RTV request document which will start failing retries.
43. The message from RMS is still not processing into SIM because SIM states that the Vendor Return cannot be modified in a status of APPROVED.




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.