Results for “zx_lines_s”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG package is an internal Oracle E-Business Tax (EBTax / ETRM) upgrade utility that supports the on-the-fly migration of Oracle Payables (AP) transaction tax data during an E-Business Suite release upgrade. E-Business Tax replaced the legacy Oracle Global Tax (Financials Tax) engine in Release 12, and historical Payables invoices that were originally taxed under the old regime must be upgraded so their tax lines conform to the new ZX data model. This package provides the Payables-specific implementation layer that processes those candidate invoices and their distributions, decomposing and re-deriving tax lines into the repository structures such as ZX_LINES and ZX_LINES_SUMMARY.

Its documented API classification is OTHER, indicating it is a private or internal helper program rather than a public, callable API. It is tightly coupled to ZX_ON_FLY_TRX_UPGRADE_PKG, the core on-the-fly transaction upgrade driver, and is not intended for direct invocation by customer code. The object is VALID in the APPS schema in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes two documented procedures:

• UPGRADE_TRX_ON_FLY_AP — Performs the on-the-fly upgrade of Payables transactions, driving the re-creation of tax lines for AP invoices processed through the upgrade path. It serves as the Payables-specific entry point invoked by the parent on-the-fly upgrade logic.
• UPGRADE_TRX_ON_FLY_BLK_AP — Provides the bulk (BLK) processing variant of the same upgrade operation, allowing Payables transactions to be upgraded in batches rather than one transaction at a time, improving throughput during large-volume upgrades.

Parameter lists are not documented in the available metadata and are therefore omitted; the procedures are described by purpose only. Both delegate to or are coordinated by ZX_ON_FLY_TRX_UPGRADE_PKG.

Tables Accessed

The package reads and, where applicable, writes AP and tax tables through APPS synonyms. On the Payables side it accesses AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_INV_DISTS_TARGET to obtain invoice headers, lines, distributions, and the derived distribution tax basis. Supplier and purchasing context is drawn from AP_SUPPLIER_SITES_ALL and PO_LINE_LOCATIONS_ALL. Tax configuration and party tax attributes are sourced from ZX_PARTY_TAX_PROFILE, XLE_ETB_PROFILES, and FND_CURRENCIES. The core tax repository is populated through ZX_LINES, ZX_LINES_S, ZX_LINES_SUMMARY, and ZX_LINES_DET_FACTORS, with FND_DOCUMENT_SEQUENCES supplying document numbering and FND_PRODUCT_GROUPS providing installation context.

Usage Notes

This package is invoked during the E-Business Tax upgrade when Payables tax data is migrated on the fly, typically driven by upgrade-related concurrent programs or scripts that call ZX_ON_FLY_TRX_UPGRADE_PKG. It is not exposed through a standard form or a public concurrent program interface for direct customer execution. Custom code should never call ZX_ON_FLY_TRX_UPGRADE_AP_PKG directly; it is a private implementation detail. The _BLK procedure is used for set-based bulk processing, while UPGRADE_TRX_ON_FLY_AP handles individual transactions. Because the package modifies core ZX and references AP data, it must be run only in the controlled context of the Oracle-provided upgrade process, with appropriate backups and under Oracle support guidance.