My Oracle Support Banner

Unique Constraint Error Received when Updating a Contract using the CNTRCT_ENTRY Component Interface (Doc ID 2818270.1)

Last updated on MARCH 18, 2022

Applies to:

PeopleSoft Enterprise SCM Supplier Contract Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unique Constraint Error Received when Updating a Contract using the CNTRCT_ENTRY Component Interface

ERROR


The issue can be reproduced at will with the following steps:
1. Log into DEMO  App Designer and open component interface CNTRCT_ENTRY
2. Highlight the component Interface name on the right and from the menu select Tool -> Test Component Interface.
3. Choose the ‘Create’ function and enter the keys for SETID, CNTRCT_ID and CNTRCT_PROC_OPT as shown.
4. Fill in the rest of the values as per the screenshot. Note: Allow Open Items must be Y
5. Save the Component Interface. It saves Ok
6. Save the Component Interface again
7. Get an error
SQL error. Function: SQLExec Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_CNTRCT_RLS_TBL)violated Statement: INSERT INTO PS_CNTRCT_RLS_TBL (SETID, CNTRCT_ID, LAST_RELEASE_NBR) VALUES (:1, :2, :0)
SQL error in Exec. (2,280) CNTRCT_HDR.CNTRCT_ID.SavePreChange

Changes

 

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
Changes
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.