Return to Vendor (RTV) Message Fails in RIB with Unique Constraint (RMS13.PK_RTVREQ_PUB_INFO) Violated
Last updated on JULY 05, 2017
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
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