Search Results ap_dist_line_gt

Overview

AP_LINES_UPGRADE_PKG is an Oracle Payables upgrade utility package owned by the APPS schema. Its role is to support the migration of invoice distribution and line data during release upgrades into Oracle E-Business Suite 12.1.1 and 12.2.2. The package operates against the pre-upgrade and post-upgrade staging infrastructure used by Payables, notably the source and target distribution tables (AP_INV_DISTS_SOURCE and AP_INV_DISTS_TARGET), the upgrade control table (AP_INVOICES_UPG_CONTROL), and related global temporary tables. Where earlier versions handled distribution lines independently, this package belongs to the family of concurrent, parallel-enabled upgrade workers that transform legacy invoice line and distribution rows into the current data model, including tax and charge allocation records.

Key Procedures and Functions

• TRANSACTION_UPGRADE_MAIN — the primary entry point for the upgrade run. It drives the overall line upgrade process, coordinating parallel workers, reading upgrade control state, and determining the scope of work to be processed.
• TRANSACTION_UPGRADE_SUBWORKER — the parallelizable unit of execution invoked by the main driver. It processes a subset of invoice lines or distributions, applying the transformation logic and populating the target structures.
• POPULATE_LINES — populates the intermediate or target line/distribution tables with transformed data, drawing from source records and applying the required mapping and validation logic before records are committed to the final tables.

Parameter lists are not documented in the ETRM metadata and are therefore not restated here.

Tables Accessed

The package reads and writes invoice and distribution data, and it depends on a broad set of supporting tables:

• AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_S, AP_DIST_LINE_GT, AP_LINE_TEMP_GT — source invoice, line, and distribution records and the temporary holding structures used during transformation.
• AP_INV_DISTS_SOURCE, AP_INV_DISTS_TARGET — the staging tables that separate pre-upgrade distribution rows from their upgraded counterparts.
• AP_INVOICES_UPG_CONTROL — the control table governing upgrade progress and restartability.
• AP_CHRG_ALLOCATIONS_ALL, AP_TAX_ALLOC_AMOUNT_GT, AP_TAX_CODES_ALL — charge and tax allocation data carried forward during the upgrade.
• PO_DISTRIBUTIONS_ALL, PO_LINES_ALL, RCV_TRANSACTIONS — matched purchasing and receiving references retained on upgraded invoice lines.
• ZX_LINES_SUMMARY_S, ZX_RATES_B, ZX_REC_NREC_DIST_S — E-Business Tax summary and rate data used to rebuild tax lines.
• AP_SYSTEM_PARAMETERS_ALL, FND_CURRENCIES — system and currency context used during conversion.

Usage Notes

AP_LINES_UPGRADE_PKG is an internal upgrade utility rather than an application-programming interface. It is typically invoked by the Payables upgrade driver, often under the parallel update framework exposed through AD_PARALLEL_UPDATES_PKG, with worker identity and context supplied by FND_GLOBAL and DBMS_LOCK used for serialization. Concurrent submission metadata is provided by FND_REQUEST and FND_CONCURRENT. Because the package is documented as referenced by zero other database objects, it should be treated as a private implementation detail of the upgrade process. Customers and integrators should not call its procedures directly; the documented entry points exist to support the upgrade run only, and any custom reliance on its behavior is unsupported. The presence of AP_DIST_LINE_GT in its dependency list confirms its close association with distribution-line transformation during the upgrade.