Create Accounting Process And Sub-process end in error: ORA-00001: unique constraint (FUSION.XLA_DISTRIBUTION_LINKS_U1) violated (Doc ID 2537174.1)

Last updated on OCTOBER 15, 2019

Applies to:

Symptoms

Create accounting process and subprocess for Payables ends in below error:

XLA_AP_FATAL_SQL_ERROR! Module: xla4irf_m4_insert_ref, Statement: insert into
xla_distribution links, Oracle error: ORA-00001: unique constraint
(FUSION.XLA_DISTRIBUTION_LINKS_U1) violated

Create accounting execution report  shows error message:

"There are events which could not be processed because no data could be found in transaction objects.
Cause: Some events could not be processed because no data exists in the transaction objects.
Action: Enable the profile option SLA Enable Diagnostics, create accounting again, and submit the process Accounting Event Diagnostic to identify the problem."

Try to perform online accounting for the invoice and below error occurs:

 "Engine encountered an nonrecoverable error during online accounting request
 XXXXX. Details: See log file for more information."

And invoices are stuck in 'Selected for accounting' status.

Changes

Cause

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