Search Results zx_party_tax_profile

Overview

The ZX_PARTY_TAX_PROFILE table is a core repository within the E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as the central table for storing tax profiles, which are essential configurations that define the tax attributes and compliance requirements for any entity involved in a taxable transaction. Its primary role is to act as the master reference for tax-related characteristics of both internal and external parties, enabling the E-Business Tax engine to accurately determine tax applicability, registration, and calculation based on the parties and locations involved in business documents such as invoices, purchase orders, and receipts.

Key Information Stored

Each record in ZX_PARTY_TAX_PROFILE is uniquely identified by the PARTY_TAX_PROFILE_ID primary key. The table's structure links a tax profile to a specific party or location via the PARTY_ID column, which references the HZ_PARTIES and HZ_PARTY_SITES tables. A critical attribute is the COUNTRY_CODE, which ties the profile to a specific tax jurisdiction. The table distinguishes between different profile types, such as those for first-party legal entities, third-party customers and suppliers, tax authorities, and operating units. Key columns typically include indicators for tax registration status, self-assessment eligibility, and the effective dates for the tax profile, forming the foundational tax identity for each entity within the system.

Common Use Cases and Queries

A primary use case is troubleshooting tax determination issues by verifying the existence and attributes of a party's tax profile. For instance, to validate a customer's tax profile for a specific site, a common query would join ZX_PARTY_TAX_PROFILE with HZ_PARTY_SITES and HZ_PARTIES. Reporting on tax registrations across all legal entities or identifying parties configured for self-assessment are other frequent scenarios. The table is also central in data migration and integration projects, where ensuring the correct population of party tax profiles is mandatory for subsequent tax processing. Sample SQL often involves filtering by PARTY_TYPE, COUNTRY_CODE, and effective date ranges to retrieve active configurations.

Related Objects

As indicated by the foreign key relationships, ZX_PARTY_TAX_PROFILE is a hub table with extensive dependencies. It has a fundamental relationship with the Trading Community Architecture (TCA) via HZ_PARTIES and HZ_PARTY_SITES. Crucially, it is referenced by the ZX_LINES_DET_FACTORS table, which stores the tax determination factors for transaction lines; this includes references for ship-to, bill-to, point of acceptance, and other party and site tax profiles used in calculations. Other key related objects include ZX_API_REGISTRATIONS (for tax registration numbers), ZX_CONTENT_SOURCES (for tax content providers), and the reference data table FND_TERRITORIES. This network of relationships underscores its critical position in the E-Business Tax data model.