Receiving Exception "ORA-00001: Unique Constraint (RMS.PK_RPM_PC_TICKET_REQUEST) Violated" When Approving Price Changes in RPM

(Doc ID 1177094.1)

Last updated on NOVEMBER 15, 2016

Applies to:

Oracle Retail Price Management - Version 12.0.8 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Jun-2012***


The following error is received while approving price changes in Retail Price Management (RPM).

"com.retek.platform.exception.RetekUnknownSystemException: @0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS.PK_RPM_PC_TICKET_REQUEST) violated@2RPM_CC_PUBLISH.STAGE_PC_MESSAGES exception id: 1269266208693"

Steps to Reproduce:

   1. Create a price change in RPM.
   2. Try approving it through RPM.


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