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 laterInformation 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 |