GDF Patch 16917549 Failed To Execute Script Ap_trx_missing_xdl.sql Gets Error: -60 -ERROR- ORA-00060: Deadlock Detected While Waiting For Resource (Doc ID 1579887.1)

Last updated on APRIL 04, 2016

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

GDF patch 16917549 failed to execute script ap_trx_missing_xdl.sql.
AP Period Close Helper identifies at least 1000 records with "Missing records in XLA_Distribution_Links. Solution offered in note id 1054299.1 did not execute.
First execution ended in deadlock and a large core dump; second execution (applying the patch) ended with no output in the staging table.
The script gets : An error was encountered - -60 -ERROR- ORA-00060: deadlock detected while waiting for resource.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms