Unique Constraint Error Received when Updating a Contract using the CNTRCT_ENTRY Component Interface
(Doc ID 2818270.1)
Last updated on APRIL 19, 2023
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 |