My Oracle Support Banner

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

Last updated on MAY 24, 2023

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

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
Goal
Solution


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