Results for “hz_tax_assignment_v2pub”

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

Overview

The APPS.HZ_TAX_ASSIGNMENT_V2PUB package is a public PL/SQL API within the Oracle E-Business Suite Trading Community Architecture (TCA) that manages the assignment of tax-related attributes to location records. Tax assignments in TCA establish the linkage between a party site, location, and the applicable tax regime, tax jurisdiction, and tax status used by downstream tax engines such as E-Business Tax (EBTax). The package belongs to the TCA "V2PUB" family of public APIs, a naming convention indicating a second-generation, publicly callable interface intended for use by both Oracle applications and external integrations. Its role is to create and maintain location-level tax assignments in a controlled, API-driven manner so that dependent modules — particularly Receivables, Order Management, and iStore — can resolve correct tax treatment for customer and party sites.

Key Procedures and Functions

The ETRM metadata documents four procedures/functions, of which two principal entry points are explicitly named:

• CREATE_LOC_ASSIGNMENT — Creates a new tax assignment record for a location, associating the location with the appropriate tax attributes required by the tax determination process. It returns a standard API status and message through the FND_API error-handling framework.
• UPDATE_LOC_ASSIGNMENT — Modifies an existing location tax assignment, allowing changes to tax attributes on an already-established location-to-tax mapping.

Both routines are implemented using the FND_API error-handling and validation standards, communicating success or failure via return status and message out-parameters rather than raising uncontrolled exceptions. The remaining two documented entries are internal helper routines supporting validation and write logic.

Tables Accessed

The package references the following base tables through APPS synonyms:

• HZ_LOCATIONS — The central TCA location entity; tax assignments are anchored to specific locations, so this table supplies the owning location identifier.
• HZ_LOC_ASSIGNMENTS — The primary target table holding the location tax assignment rows created and updated by this API.
• HZ_PARTY_SITES — Supplies party-site context, since tax applicability is commonly derived from the party site associated with a location.
• DUAL — Used for standard PL/SQL constructs such as sequence value retrieval and single-row validation queries.

Writes are concentrated on HZ_LOC_ASSIGNMENTS, while the remaining tables are predominantly read sources for validation and context resolution.

Usage Notes

HZ_TAX_ASSIGNMENT_V2PUB is typically invoked indirectly rather than called directly by end users. The ETRM metadata confirms it is referenced by seven dependent packages, including HZ_CUST_ACCOUNT_SITE_V2PUB, HZ_LOCATION_V2PUB, HZ_TAX_ASSIGNMENT_PUB, ARH_ADDR_PKG, ASO_OPP_QTE_PUB, IBE_ADDRESS_V2PVT, and IGS_GR_VENUE_ADDR_PKG. This indicates that location creation and update flows in TCA, Receivables address handling, quoting, and iStore address processing all delegate tax assignment maintenance to this API. Custom integrations and extension code should therefore call it through the standard FND_API conventions, supplying the location and tax attribute payload and inspecting the returned status and message. Because assignments feed the tax engine, invocation order matters: tax assignments should be established after the location and party site exist, and updates should be issued as public API calls rather than direct DML on HZ_LOC_ASSIGNMENTS to preserve validation, audit, and dependent processing. The package is valid and present in both EBS 12.1.1 and 12.2.2, maintaining consistent behavior across releases.