Create Payable Invoices Erroring Out JBO-26048: Constraint "AP_INVOICES_ALL_U2" (Doc ID 1968316.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Goal

The problem is with the next document sequence number which is being assigned. Either the document sequencing max number is reached causing the code to pick the next one which is already existing in the data base. Please see below error from log.

Caused by: javax.faces.el.EvaluationException:
oracle.jbo.DMLConstraintException: JBO-26048: Constraint "AP_INVOICES_ALL_U2"
is violated during post operation "Insert" using SQL statement "INSERT INTO
AP_INVOICES_ALL(INVOICE_ID,LAST_UPDATED_BY,SET_OF_BOOKS_ID,LAST_UPDATE_DATE,VE
NDOR
...
Caused by: oracle.jbo.DMLConstraintException: JBO-26048: Constraint
"AP_INVOICES_ALL_U2" is violated during post operation "Insert" using SQL
statement "INSERT INTO AP_INVOICES_ALL
...
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001:
unique constraint (FUSION.AP_INVOICES_ALL_U2) violated
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms