Results for “financials_system_params_u1”

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

Overview

ZX_PO_REC_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the E-Business Tax (EBTax) regime as it applies to Oracle Purchasing documents. Its central role is the recovery and reconstruction of tax-relevant information for purchase orders and releases, particularly during upgrade and on-demand tax calculation activities associated with the transition from the legacy Oracle E-Business Tax structures to the ZX (E-Business Tax) schema. The package name reflects this purpose: "PO" for Purchasing, "REC" for recovery/recalculation, and the ZX prefix denoting the E-Business Tax module.

In the context of Release 12.1.1 and 12.2.2, the package acts as a bridge between Purchasing transactional tables and the tax engine. It assembles the distribution-level data required to compute or re-derive taxes on purchasing documents, and it materializes interim results that downstream upgrade processes consume. It is classified as a generic "OTHER" API rather than a public documented interface, meaning Oracle does not certify it for direct customer invocation, but it is a load-bearing component of the E-Business Tax upgrade and on-demand upgrade infrastructure.

Key Procedures and Functions

• INIT_REC_GT_TABLES — Initializes the global temporary (GT) tables used by the package to stage recovered purchasing tax information during processing. It prepares the working structures prior to population and calculation.
• INSERT_REC_INFO — Inserts recovered tax information for purchasing documents into the package's staging structures. This is the primary data-population routine, loading distribution and document details that will subsequently be taxed or validated.
• GET_REC_INFO — Retrieves the recovered tax information assembled by the preceding routines, returning the results to the calling upgrade or tax-recovery process.

Additional internal procedures and functions are documented in the ETRM metadata as part of the five total subprograms; the three named above constitute the documented public surface of the package. Parameters are intentionally omitted here, as the package is invoked internally by sibling upgrade packages rather than by end users.

Tables Accessed

The package reads and writes a combination of Purchasing, payables, general ledger, and E-Business Tax tables, accessed through APPS synonyms. Purchasing document structures — PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS_ALL — supply the header, line, shipment, and distribution context required for taxation. Supplier information is drawn from PO_VENDORS and PO_VENDOR_SITES_ALL. Tax configuration and setup data come from AP_TAX_CODES_ALL and AR_TAX_GROUP_CODES_ALL, while financial context such as ledgers and system parameters is obtained from GL_LEDGERS and FINANCIALS_SYSTEM_PARAMS_ALL.

E-Business Tax staging and reference objects — ZX_PO_REC_DIST, ZX_RATES_B, ZX_VALIDATION_ERRORS_GT, and XLA_UPGRADE_DATES — hold recovered distribution results, tax rates, validation errors, and upgrade date boundaries. The package also references PLITBLM and calls into ZX_ON_FLY_TRX_UPGRADE_PKG, embedding it within the broader on-the-fly upgrade framework.

Usage Notes

ZX_PO_REC_PKG is not intended for direct customer invocation. It is referenced by two higher-level upgrade packages, ZX_ON_DEMAND_TRX_UPGRADE_PKG and ZX_ON_FLY_TRX_UPGRADE_PO_PKG, which orchestrate on-demand and on-the-fly tax upgrade processing. The package is typically executed through these parent packages, or through the concurrent programs that drive E-Business Tax upgrade and tax recovery for purchasing transactions. It does not appear as a form-level API and should be treated as an internal implementation object. Customizations that require purchasing tax recovery should call the parent upgrade packages rather than ZX_PO_REC_PKG directly, and any dependency on its procedures should be revalidated during patching, since Oracle may alter internal signatures without notice.