Search Results zx_party_tax_profile




Overview
Explore in AI Chat

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.

  • Table: ZX_PARTY_TAX_PROFILE 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_PARTY_TAX_PROFILE 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE,  object_name:ZX_PARTY_TAX_PROFILE,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. ,  implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE , 

  • Table: ZX_LINES_DET_FACTORS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_LINES_DET_FACTORS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_DET_FACTORS,  object_name:ZX_LINES_DET_FACTORS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event class. ,  implementation_dba_data: ZX.ZX_LINES_DET_FACTORS , 

  • Table: ZX_REGISTRATIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGISTRATIONS,  object_name:ZX_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax registrations. ,  implementation_dba_data: ZX.ZX_REGISTRATIONS , 

  • Table: ZX_REGISTRATIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGISTRATIONS,  object_name:ZX_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax registrations. ,  implementation_dba_data: ZX.ZX_REGISTRATIONS , 

  • Table: ZX_LINES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_TAXES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_TAXES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TAXES_B,  object_name:ZX_TAXES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner. ,  implementation_dba_data: ZX.ZX_TAXES_B , 

  • Table: ZX_LINES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES,  object_name:ZX_LINES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores detail tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES , 

  • Table: ZX_SUBSCRIPTION_DETAILS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_DETAILS,  object_name:ZX_SUBSCRIPTION_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_DETAILS , 

  • Table: ZX_SUBSCRIPTION_DETAILS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_DETAILS,  object_name:ZX_SUBSCRIPTION_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_DETAILS , 

  • Table: ZX_LINES_SUMMARY 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_LINES_SUMMARY 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_LINES_SUMMARY,  object_name:ZX_LINES_SUMMARY,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the summarized tax lines for transactions of multiple event classes. ,  implementation_dba_data: ZX.ZX_LINES_SUMMARY , 

  • Table: ZX_REGIMES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Table: ZX_REGIMES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_B,  object_name:ZX_REGIMES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process. ,  implementation_dba_data: ZX.ZX_REGIMES_B , 

  • Lookup Type: ZX_REPORTING_TABLE_USE 12.1.1

    product: ZX - E-Business Tax ,  meaning: Reporting Types Table uses , 

  • Table: ZX_REGIMES_USAGES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_USAGES,  object_name:ZX_REGIMES_USAGES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have tax implications. ,  implementation_dba_data: ZX.ZX_REGIMES_USAGES , 

  • Table: ZX_STATUS_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_TRX_LINE_APP_REGIMES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TRX_LINE_APP_REGIMES,  object_name:ZX_TRX_LINE_APP_REGIMES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line. ,  implementation_dba_data: ZX.ZX_TRX_LINE_APP_REGIMES , 

  • Table: ZX_SRVC_SUBSCRIPTIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SRVC_SUBSCRIPTIONS,  object_name:ZX_SRVC_SUBSCRIPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table. ,  implementation_dba_data: ZX.ZX_SRVC_SUBSCRIPTIONS , 

  • Lookup Type: ZX_REPORTING_TABLE_USE 12.2.2

    product: ZX - E-Business Tax ,  meaning: Reporting Types Table uses , 

  • Table: ZX_CONTENT_SOURCES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_REGIMES_USAGES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIMES_USAGES,  object_name:ZX_REGIMES_USAGES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have tax implications. ,  implementation_dba_data: ZX.ZX_REGIMES_USAGES , 

  • Table: ZX_SRVC_SUBSCRIPTIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SRVC_SUBSCRIPTIONS,  object_name:ZX_SRVC_SUBSCRIPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table. ,  implementation_dba_data: ZX.ZX_SRVC_SUBSCRIPTIONS , 

  • Table: ZX_TRX_LINE_APP_REGIMES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_TRX_LINE_APP_REGIMES,  object_name:ZX_TRX_LINE_APP_REGIMES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line. ,  implementation_dba_data: ZX.ZX_TRX_LINE_APP_REGIMES , 

  • Table: ZX_SUBSCRIPTION_OPTIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_OPTIONS,  object_name:ZX_SUBSCRIPTION_OPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_OPTIONS , 

  • Table: ZX_SUBSCRIPTION_OPTIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_SUBSCRIPTION_OPTIONS,  object_name:ZX_SUBSCRIPTION_OPTIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIMES_USAGES table. ,  implementation_dba_data: ZX.ZX_SUBSCRIPTION_OPTIONS , 

  • Table: ZX_CONTENT_SOURCES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONTENT_SOURCES,  object_name:ZX_CONTENT_SOURCES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a specific regime. ,  implementation_dba_data: ZX.ZX_CONTENT_SOURCES , 

  • Table: ZX_STATUS_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_STATUS_B,  object_name:ZX_STATUS_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner. ,  implementation_dba_data: ZX.ZX_STATUS_B , 

  • Table: ZX_API_REGISTRATIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_API_REGISTRATIONS,  object_name:ZX_API_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registration of one API for a third party service provider or a first party organization. ,  implementation_dba_data: ZX.ZX_API_REGISTRATIONS , 

  • Table: ZX_API_REGISTRATIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_API_REGISTRATIONS,  object_name:ZX_API_REGISTRATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registration of one API for a third party service provider or a first party organization. ,  implementation_dba_data: ZX.ZX_API_REGISTRATIONS , 

  • Table: ZX_RULES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_RULES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RULES_B,  object_name:ZX_RULES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. ,  implementation_dba_data: ZX.ZX_RULES_B , 

  • Table: ZX_PROCESS_RESULTS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS , 

  • Table: ZX_REC_NREC_DIST 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_REC_NREC_DIST 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REC_NREC_DIST,  object_name:ZX_REC_NREC_DIST,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. ,  implementation_dba_data: ZX.ZX_REC_NREC_DIST , 

  • Table: ZX_PROCESS_RESULTS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PROCESS_RESULTS,  object_name:ZX_PROCESS_RESULTS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. ,  implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,