Search Results transaction_upgrade_subworker

Overview

APPS.AP_LINES_UPGRADE_PKG is an internal Oracle Payables package that supports data migration and upgrade processing for invoice line and distribution records during Oracle E-Business Suite upgrades, particularly along the 12.1.1 to 12.2.2 upgrade path. Its principal business function is to transform legacy invoice line data into the structures required by the enhanced Payables data model, ensuring that invoice lines, distributions, tax allocations, and charge allocations remain consistent after upgrade. The package does not expose a public, customer-facing API classification — its API classification is documented as OTHER — and it is intended for use by Oracle's own upgrade driver scripts rather than by end-user extensions. It is owned by the APPS schema, carries a VALID status, and depends on SYS.STANDARD as its only listed external dependency.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within this package:

• TRANSACTION_UPGRADE_MAIN — The principal entry point that orchestrates the line upgrade for a transaction (invoice). It coordinates the overall processing flow and drives the subordinate upgrade routines that follow.
• TRANSACTION_UPGRADE_SUBWORKER — A supporting worker routine invoked by the main driver to perform the detailed upgrade work on individual transaction records or batches.
• POPULATE_LINES — Responsible for populating invoice line records from the temporary or source upgrade structures into the target Payables line tables.

The package body is largely consumed by other routines within the AP_LINES_UPGRADE_PKG dependency chain, and it is not referenced by any other documented APPS packages, confirming its role as a terminal, upgrade-only utility.

Tables Accessed

The package reads and writes a broad set of Payables and Purchasing tables via APPS synonyms, including:

• Invoice and line tables: AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_S.
• Upgrade control and staging tables: AP_INVOICES_UPG_CONTROL, AP_INV_DISTS_SOURCE, AP_INV_DISTS_TARGET, AP_LINE_TEMP_GT, AP_DIST_LINE_GT, AP_TAX_ALLOC_AMOUNT_GT.
• Allocation and tax reference tables: AP_CHRG_ALLOCATIONS_ALL, AP_TAX_CODES_ALL.
• Setup and reference data: AP_SYSTEM_PARAMETERS_ALL, FND_CURRENCIES.
• Purchasing tables: PO_DISTRIBUTIONS_ALL, PO_LINES_ALL — used to validate or reconcile matched invoice lines against their originating purchase order distributions.

These tables collectively support the transformation of invoice line and distribution data, including tax and charge allocation amounts, from source to target structures.

Usage Notes

AP_LINES_UPGRADE_PKG is an Oracle-internal upgrade utility and is not intended for direct invocation by customers or custom code. It is typically called by Oracle's Payables upgrade driver scripts and concurrent programs executed during the E-Business Suite upgrade process, most notably where invoice line and distribution restructuring is required. Because the package manipulates core Payables transactional tables, it should only be run in the prescribed upgrade sequence defined by Oracle, with adequate backups in place. The presence of staging and global temporary tables (AP_LINE_TEMP_GT, AP_DIST_LINE_GT, AP_TAX_ALLOC_AMOUNT_GT) confirms that the package operates in a controlled, migration-oriented context rather than during normal transactional processing. Customers should not wrap, extend, or call this package directly.