My Oracle Support Banner

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 later
Oracle 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


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