Search Results create_invoice_dist_links

Overview

APPS.AP_XLA_UPGRADE_PKG is a Payables upgrade utility package that supports the migration of Oracle Payables transaction data into the Subledger Accounting (XLA) model during an Oracle E-Business Suite upgrade or on-demand data conversion. It is primarily responsible for creating the distribution link records that associate Payables accounting distributions with their corresponding Subledger Accounting events and journal entries. In the 12.1.1 and 12.2.2 code lines, this package is executed as part of the upgrade path from pre-XLA Payables accounting to the XLA-based accounting engine, ensuring that historical invoice, prepayment, and payment distributions are correctly mapped so that Subledger Accounting can generate and maintain valid accounting entries.

Key Procedures and Functions

The package exposes six documented procedures:

• AP_XLA_UPGRADE_ONDEMAND — The top-level driver procedure, invoked as a concurrent program to initiate the upgrade process. It accepts a batch size and a worker count and manages the overall execution.
• AP_XLA_UPGRADE_SUBWORKER — The worker procedure that performs the batch processing. It receives a batch size, worker identifier, total worker count, and the invoice and payment script names, and coordinates the parallel processing of distribution link creation.
• CREATE_INVOICE_DIST_LINKS — Creates the distribution link records for invoice distributions. It processes records bounded by starting and ending ROWID values and receives a calling sequence identifier for diagnostics.
• CREATE_PREPAY_DIST_LINKS — Creates the equivalent distribution link records for prepayment distributions, using the same ROWID-bounded range and calling sequence parameters.
• CREATE_PAYMENT_DIST_LINKS — Creates the distribution link records for payment distributions, again bounded by ROWID range with a calling sequence parameter.
• CREATE_TRIAL_BALANCE — Supports trial balance processing for a given ledger, operating in a specified mode and returning status, message count, and message data through output parameters along with the calling sequence.

Tables Accessed

The package reads and writes numerous Payables tables through APPS synonyms. Core invoice tables include AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL. Control and source tables include AP_INVOICES_UPG_CONTROL and AP_INV_DISTS_SOURCE. Payment-related processing uses AP_CHECKS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS, and AP_PAYMENT_HIST_DISTS_S. Prepayment processing uses AP_PREPAY_APP_DISTS, AP_PREPAY_APP_DISTS_S, AP_PREPAY_HISTORY_ALL, and AP_PREPAY_HISTORY_S. Liability balances are read from AP_LIABILITY_BALANCE. These tables provide the source distributions, historical records, and control information used to construct the XLA distribution links.

Usage Notes

AP_XLA_UPGRADE_PKG is typically invoked during the Oracle Payables upgrade to Release 12 as part of the XLA migration, or on demand through the AP_XLA_UPGRADE_ONDEMAND concurrent program when distribution links must be regenerated. The subworker procedure supports parallel execution for large data volumes. The ROWID-based parameters on the three link-creation procedures reflect a design intended to partition large distribution sets across workers efficiently. Because the package is owned by APPS and declared AUTHID CURRENT_USER, it must be executed in an environment with appropriate APPS schema privileges. Custom code should not call the internal link-creation procedures directly unless performing controlled data repair, as sequencing and completeness are normally managed by the driver and worker procedures.