My Oracle Support Banner

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

Last updated on JUNE 29, 2021

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.