Return to Vendor (RTV) Message Fails in RIB with Unique Constraint (RMS13.PK_RTVREQ_PUB_INFO) Violated
(Doc ID 2094304.1)
Last updated on SEPTEMBER 16, 2019
Applies to:
Oracle Retail Store Inventory Management - Version 13.0.7 and laterInformation in this document applies to any platform.
Symptoms
In Store inventory Management (SIM) application, find that, Return to Vendor (RTV) incorrectly sends out a delete message to Retail Merchandise System (RMS), when trying to cancel the changes made to RTV. As a result, the RTV in RMS was deleted. When the user opens the same RTV in SIM and try to enter receive quantity and save it, the subsequent message published to RMS fails in RIB with the following error:
-----
javax.ejb.EJBException: Exception while processing request: Error from {call RMSSUB_RTV.CONSUME(?,?,?,?)}: [E] PACKAGE_ERROR:ORA-20001: @0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS13.PK_RTVREQ_PUB_INFO) violated@2RMSMFM_RTVREQ.ADDTOQ ORA-06512: at RMS13.EC_TABLE_RHD_AIUDR", line 79
Steps to reproduce:
1. Create a RTV in Retail Merchandise System(RMS) with two line items.
2. In SIM open the RTV, enter Qty as 0 for both items.
3. Click on 'Done' button.
4. The message "This Return does not contain any items and will be cancelled." is displayed
5. Click on Cancel button to cancel the data entry by user.
6. Control returns to the Return List screen and item quantity is updated as 0 in SIM. SIM also sends a message to RMS, as a result the RTV is purged in RMS.
7. In SIM, open the same RTV and enter received quantity and save it. Observe the above error.
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 |