My Oracle Support Banner

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.


 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:

  1. Log into Oracle applications using a Payables responsibility.
  2. Open the Invoice Workbench
        (N) Invoices > Entry > Invoices
        Query an upgraded Invoice > Apply / Unapply  prepayments or Cancel invoice or Make a Payment
  3. Click on the [Actions] button
  4. 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.





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

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