Create Payable Invoices Erroring Out JBO-26048: Constraint "AP_INVOICES_ALL_U2"
(Doc ID 1968316.1)
Last updated on JULY 31, 2020
Applies to:Oracle Fusion Payables Cloud Service - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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
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
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