Results for “withholding_start_date”

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

Overview

The ZX_PARTY_TAX_PROFILE table is a core configuration and reference object within the Oracle E-Business Tax (E-Business Tax / ZX) module of Oracle EBS 12.1.1 and 12.2.2. It stores tax profiles for a broad set of parties involved in tax determination, including third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units, and tax authorities. Each row represents the tax characteristics and behavioral flags that govern how E-Business Tax treats a given party or party site during tax calculation, registration, withholding, and reporting.

The table sits at the center of the party-level tax configuration model. It links parties defined in the Trading Community Architecture (HZ_PARTIES, HZ_PARTY_SITES) to tax registrations, tax regimes, tax rules, content sources, and transaction-level tax determination factors. From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying ZX_PARTY_TAX_PROFILE as a hub, since it holds a stable surrogate primary key (PARTY_TAX_PROFILE_ID) referenced by many dependent tables, with business attributes attached around it.

Key Information Stored

The table has 56 documented columns. The most significant are summarized below.

• PARTY_TAX_PROFILE_ID — Surrogate primary key of the table (ZX_PARTY_TAX_PROFILE_PK), used as the foreign key target by dependent tables such as ZX_REGISTRATIONS and ZX_LINES_DET_FACTORS.
• PARTY_ID and PARTY_TYPE_CODE — Together form unique index ZX_PARTY_TAX_PROFILE_U2, the principal business-key candidate. PARTY_ID references HZ_PARTIES and HZ_PARTY_SITES; PARTY_TYPE_CODE identifies whether the profile belongs to a third party, first party legal entity, legal establishment, operating unit, or tax authority.
• COUNTRY_CODE — References FND_TERRITORIES and identifies the country context of the profile.
• REGISTRATION_TYPE_CODE and REP_REGISTRATION_NUMBER — Capture the registration type and reporting registration number associated with the party profile.
• PARTY_TYPE-specific flags — SUPPLIER_FLAG, CUSTOMER_FLAG, SITE_FLAG, LEGAL_ESTABLISHMENT_FLAG, FIRST_PARTY_LE_FLAG, REPORTING_AUTHORITY_FLAG, COLLECTING_AUTHORITY_FLAG, and PROVIDER_TYPE_CODE distinguish the role and capabilities of the configured party.
• WITHHOLDING_START_DATE, ALLOW_AWT_FLAG, INCLUSIVE_TAX_FLAG, SELF_ASSESS_FLAG, and ALLOW_OFFSET_TAX_FLAG — Govern withholding, inclusive tax, self-assessment, and offset tax behavior.
• ROUNDING_LEVEL_CODE and ROUNDING_RULE_CODE — Control rounding behavior at the party level.
• MERGED_TO_PTP_ID and MERGED_STATUS_CODE — Support party merge processing and duplicate profile consolidation.
• Audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, PROGRAM_ID, and OBJECT_VERSION_NUMBER follow standard EBS concurrency and audit conventions.

Common Use Cases and Queries

Typical scenarios involve retrieving the tax profile for a specific party or site, validating configuration before tax calculation, and tracing where a profile is consumed during transaction tax determination.

• Look up a party's tax profile by party and profile type: SELECT party_tax_profile_id, party_id, party_type_code, country_code FROM zx_party_tax_profile WHERE party_id = :p_party_id AND party_type_code = :p_type;
• Identify legal establishments and first party legal entities for subscriptions and regimes: filter on LEGAL_ESTABLISHMENT_FLAG and FIRST_PARTY_LE_FLAG.
• Report tax authorities used as reporting or collecting authorities for regimes and taxes.
• Locate providers and content sources (via ZX_CONTENT_SOURCES.PROVIDER_ID) for tax content subscriptions.
• Audit withholding and inclusive-tax configuration for a legal entity or operating unit.

Related Objects

• HZ_PARTIES and HZ_PARTY_SITES — Joined on PARTY_ID; provide the party master and site definitions for profiles.
• FND_TERRITORIES — Joined on COUNTRY_CODE for territory validation.
• ZX_REGISTRATIONS — References PARTY_TAX_PROFILE_ID, TAX_AUTHORITY_ID, REP_TAX_AUTHORITY_ID, and COLL_TAX_AUTHORITY_ID, binding registrations to the profile.
• ZX_LINES_DET_FACTORS — References the profile through many determinants (SHIP_TO_PARTY_TAX_PROF_ID, BILL_TO_PARTY_TAX_PROF_ID, POA_PARTY_TAX_PROF_ID, POO_PARTY_TAX_PROF_ID, and site equivalents) during tax determination.
• ZX_LINES and ZX_LINES_SUMMARY — Reference CONTENT_OWNER_ID and TAX_PROVIDER_ID.
• ZX_REGIMES_B and ZX_TAXES_B — Reference REP_TAX_AUTHORITY_ID and COLL_TAX_AUTHORITY_ID.
• ZX_API_REGISTRATIONS and ZX_CONTENT_SOURCES — Reference API_OWNER_ID and PROVIDER_ID respectively.
• ZX_EXEMPTIONS — References PARTY_TAX_PROFILE_ID for exemption configuration.
• ZX_PARTY_TAX_PROFILE_INT — The interface table used for bulk loading and migration of party tax profiles.