R12:AP: Generic Data Fix (GDF) Patch to Populate Missing XDL for Upstream Transactions (Doc ID 1054322.1)

Last updated on APRIL 29, 2023

Applies to:

Oracle Payables - Version 12.1.3 to 12.2.12 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Upgraded invoices (upstream transactions) from R11i are missing their distribution links in XLA_Distribution_Links (XDL) in R12 as the Upgrade process / Sub-ledger Accounting (SLA) Hot Patch was not run for them. Without XDL links the accounting process fails to determine proper accounting for any subsequent account events based on the transaction.

If an upgraded invoice is missing its XDL in R12 and needs prepayment to be applied/unapplied or cancelled or to be paid then accounting of these subsequent events or Payments ( downstream transactions) can not be completed.

Steps to Reproduce:

Log into Oracle applications using a Payables responsibility.
Open the Invoice Workbench
(N) Invoices > Entry > Invoices
Query an upgraded Invoice > Apply / Unapply prepayments or Cancel invoice or Make a Payment
Click on the [Actions] button
Account Invoice / Payment
Online accounting: Click on the [Actions] button > Create accounting
Batch accounting: Other > Request > Run > Create accounting program

Upstream events for upgraded transactions like prepayment application or payment created show below error during accounting process:

Error 0: This line cannot be accounted until the accounting event for the application Payables that it references has been fully accounted

Accounting program shows below error for such upstream transactions:

The following REVERSAL events could not be processed. The event/process status is U/U:
Note: this warning may be ignored for any events whose ledger is a cash-basis ledger
Event xxxx of ledger xxxx

The Generic Data Fix (GDF) scripts resolve above two cases.