Getting Unique Constraint (OKC.OKC_CONTRACT_DOCS_U1) Violated Error When Duplicating A Contract (Doc ID 1633507.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Procurement Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Contracts Repository

When attempting to duplicate certain Contracts, the following error occurs.

ERROR
-----------------------
1. Program Error: An unexpected error was encountered. Error code - - 1 Error message - ORA-0001: unique constraint (OKC.OKC_CONTRACT_DOCS_U1) violated Action: Please contact your system administrator.
2. Program Error: An unexpected error was encountered. Error code - - 1 Error message - User-Defined Exception Action: Please contact your system administrator.

Steps to Reproduce

1. Responsibility :  Contracts Workbench Administrator

2. Navigation  : Contracts

Open a signed Contract and using the drop down from Actions select Duplicate option and enter effective and expiration dates and click Apply when the errors are thrown.

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