R12: AP/OIE: Attempting To Update Approver Name Getting UNIQUE CONSTRAINT Error
(Doc ID 3033234.1)
Last updated on NOVEMBER 12, 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
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 |