Return to Vendor (RTV) Message Fails in RIB with Unique Constraint (RMS13.PK_RTVREQ_PUB_INFO) Violated (Doc ID 2094304.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 13.0.7 and later
Information 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:

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