Search Results zx_party_tax_profile_pkg




Overview
Explore in AI Chat

Overview

The APPS.ZX_PARTY_TAX_PROFILE_PKG package is a core E-Business Tax (EBTax / ETRM) infrastructure component within Oracle EBS 12.1.1 and 12.2.2. Its primary business function is to manage the persistence and lifecycle of party tax profiles — the records that associate a given party (customer, supplier, or internal organization) with tax registration numbers, tax regimes, and the registration status used for tax determination. These records are captured in the Regime-to-Rate (R2R) flow and consumed during transaction tax calculation. In the ETRM 12.2.2 metadata the package is classified as an API of type OTHER, meaning it is an internal, non-public interface rather than a supported open API. Its valid status confirms it is compiled and active in the APPS schema, and it carries a direct dependency on the SYS.STANDARD package, which is typical of PL/SQL packages that raise application errors and expose standard PL/SQL constructs.

Key Procedures and Functions

The package exposes six documented subprograms. Their purposes are as follows:

  • INSERT_ROW — Creates a new party tax profile record, populating the base and translated tables required to register a party's tax profile within ETRM.
  • UPDATE_ROW — Modifies an existing party tax profile, allowing attributes such as tax registration details and associated regime information to be changed.
  • DELETE_ROW — Removes a party tax profile, supporting the routine that retires or supersedes a party's tax registration data.
  • SYNC_TAX_REG_NUM — Synchronizes tax registration numbers between the party tax profile and the associated registration sources, ensuring consistency of the registration number across ETRM structures.

Two additional subprograms are documented for the package but are not individually detailed in the available metadata. Consistent with the naming convention above, the remaining routines support additional maintenance and synchronization operations for the party tax profile.

Tables Accessed

The package operates against the following objects, referenced through APPS synonyms:

  • ZX_PARTY_TAX_PROFILE — The primary base table holding party tax profile definitions.
  • ZX_PARTY_TAX_PROFILE_S — The translated ("_S" or "_TL" style) companion table storing language-specific descriptive content for the same profiles.
  • HZ_PARTIES — The Trading Community Architecture (TCA) registry of parties; the package references this table to validate and associate profiles with the correct party.
  • DUAL — Used for single-row SQL constructs such as sequence retrieval or scalar evaluations.

Collectively, these tables confirm the package's role in aligning TCA party data with ETRM tax profile data.

Usage Notes

The package is not intended for direct invocation by end users or custom code. It functions as a dependency of higher-level ETRM and TCA interfaces. In the ETRM metadata it is referenced by eight other packages, including AP_VENDOR_PUB_PKG, HZ_PARTY_SITE_V2PUB, HZ_PARTY_V2PUB, POS_VENDOR_REG_PKG, and ZX_HR_ORG_INFO_USER_HOOK. This dependency pattern shows that party creation and update flows in Payables (suppliers), Trading Community Architecture (parties and party sites), and HR organization user hooks all call into this package to keep party tax profiles synchronized. It is also self-referenced, indicating internal recursive calls. Typical invocation therefore occurs through public TCA and supplier APIs, ETRM user hooks, and E-Business Tax setup processes rather than through Oracle Forms or standalone concurrent programs. Because it is classified as OTHER and is an internal ETRM object, customers and integrators should treat it as an unsupported interface and route any party tax profile maintenance through the supported TCA and Payables APIs that call it.