WSHINTERFACES: Interface Trip Stop - SRS Is Completed With Warning ORA-00001: unique constraint (QP.QP_LIMIT_TRANSACTIONS_U1) violated (Doc ID 2212673.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Oracle Shipping Execution - Version 12.1.3 and later
Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pricing, Discounting & Charges

When attempting to run the interface trip stop
the following error occurs.

ERROR
-----------------------
Other Error in Process_Limits
ORA-00001: unique constraint (QP.QP_LIMIT_TRANSACTIONS_U1) violated


CHANGES
-----------------------
The issue is in Test instance now.
Recently applied the RPC5 patches and also mandatory security patches applied in this instance.
Conducting integration testing and we want to move the patches to Production next month.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run interface trip stop
2. Review log file


SCRIPT OUTPUT
==============

13430571




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