R12: AP/OIE: Attempting To Update Approver Name Getting UNIQUE CONSTRAINT Error
(Doc ID 3033234.1)
Last updated on JULY 23, 2024
Applies to:
Oracle Internet Expenses - Version 12.2.3 and laterOracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
Symptoms
When attempting to update the approver name the following error occurs.
APP-SQLAP-10000: ORA -00001:unique constraint (AP.AP_WEB_SIGNING_LIMIT _U1) violated occurred in & CALLING SEQUENCE with parameters (&PARAMETERS) while performing the following operation: UPDATE_ROW HAS EXCEPTION (PARAMENTERS=X_ROWID=AABAv3GRAAC3xNAAE,X_DOCUMENT_TYPE=APEXP,X_LAST_UPDATE_DATE=DD-MON-YY,X_LAST_UPDATED_BY=XXXX,X_LAST_UPDATE_LOFIN=YYYYYY,X_ORG_ID=ZZZ)
The issue can be reproduced at will with the following steps:
1. Payables responsibility(N)>Employees>Signing limits
2. Query the employee and and update the record with new approver
3. Error occurred
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 |