My Oracle Support Banner

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 later
Information in this document applies to any platform.


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. 


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.