Search Results derive_line_ext_attr

Overview

ZX_VTX_USER_PKG is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Tax (EBTax / ETRM) architecture in Oracle EBS 12.1.1 and 12.2.2. Its role is to support the Vertex third-party tax integration by deriving header-level and line-level external (extension) attributes that are required when tax determination is delegated to an external tax engine. Within the ETRM stack, EBS collects transactional facts from the underlying order, receivable, and customer tables, wraps them into a geocode provider payload, and hands that payload to the external engine. This package contributes the user-defined-attribute portion of that payload.

The package is classified as OTHER, meaning it is not a public, supported extension API intended for direct customer invocation, but rather an internal provider-side utility. It is validated, references a small, well-defined set of ETRM and non-ETRM objects, and is referenced by one other package, ZX_R11I_TAX_PARTNER_PKG, which confirms its position as a downstream helper in the tax partner call path.

Key Procedures and Functions

• DERIVE_HDR_EXT_ATTR — Derives the header-level external attributes for a tax transaction. These are the document/header extension values that the external tax provider expects to receive alongside the transaction header, typically sourced from the customer transaction or order header context.
• DERIVE_LINE_EXT_ATTR — Derives the line-level external attributes for each tax line. These populate the line extension structure passed to the provider, drawing on the line-level detail factors and the provider line extension global temporary table.

Both procedures are internally oriented: they populate and read a global temporary table (ZX_PRVDR_LINE_EXTNS_GT) and surface data through the view ZX_USER_PROC_INPUT_V. Parameter lists are not documented in the ETRM metadata and should be confirmed against the live package specification in the target instance.

Tables Accessed

• ZX_LINES_DET_FACTORS — line-level tax determination factors used as the source of derived line attributes.
• ZX_PARTY_TAX_PROFILE — party tax profiles supplying tax registration and configuration context.
• ZX_PRVDR_LINE_EXTNS_GT — the provider line extensions global temporary table populated with the derived external attributes.
• AR_ADJUSTMENTS, AR_RECEIVABLES_TRX, RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL — receivables transactions and adjustments constituting the tax document.
• OE_ORDER_LINES_ALL, OE_SYSTEM_PARAMETERS_ALL — order lines and order setup used when the source document is a sales order.
• HZ_CUST_ACCOUNTS, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_LOCATIONS, HR_LOCATIONS_ALL — customer, site, party, and location data underpinning place-of-supply and jurisdiction facts.
• MTL_SYSTEM_ITEMS — inventory item attributes relevant to product taxability.

Usage Notes

ZX_VTX_USER_PKG is invoked indirectly during external tax provider processing, most notably from ZX_R11I_TAX_PARTNER_PKG, which is itself part of the tax partner plumbing. It is not attached to a form or a standalone concurrent program in the documented metadata.

Because the package is classified OTHER and references a global temporary table, it is not a candidate for direct customer extension. Customers requiring custom header or line attributes to flow to the external tax engine should use the supported EBS Tax extensibility mechanisms (for example, the tax partner and user-defined attribute hooks) rather than modifying or calling ZX_VTX_USER_PKG directly. Any change to the package invalidates it and may break the calling chain from ZX_R11I_TAX_PARTNER_PKG. Administrators should confirm validity with a standard compilation check after patching, and developers should treat the object as internal when tracing tax determination failures.