My Oracle Support Banner

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:

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

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

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
Changes
Cause
Solution
References


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