Search Results zx_regimes_b




Overview
Explore in AI Chat

Overview

The ZX_REGIMES_B table is a core master data table within the Oracle E-Business Tax (ZX) module for both EBS 12.1.1 and 12.2.2. It serves as the foundational repository for defining tax regimes, which are the highest-level tax entities in the system. A tax regime represents a distinct body of tax law, such as a national Value Added Tax (VAT), a state sales tax, or a local jurisdiction tax. This table stores the essential administrative and descriptive attributes for each regime, establishing the primary key for the entire tax configuration hierarchy. Every defined tax, rule, status, and reporting type within E-Business Tax must be associated with a valid regime stored in this table, making it a critical point of integration and reference.

Key Information Stored

The table's primary key is the TAX_REGIME_CODE, a unique identifier for the regime. Beyond this identifier, the table holds attributes that govern the regime's behavior and defaults. Key columns include COUNTRY_CODE (linking to FND_TERRITORIES), TAX_CURRENCY_CODE, and EXCHANGE_RATE_TYPE, which define the geographical and monetary context. It also stores default party types for registration (DEF_REGISTR_PARTY_TYPE_CODE) and references to default tax authorities for representation and collection (REP_TAX_AUTHORITY_ID, COLL_TAX_AUTHORITY_ID). The PARENT_REGIME_CODE column supports hierarchical regime structures, allowing for sub-regimes. Additional columns facilitate setup, such as default tax calculation rounding rules, effective dates, and a threshold check template code (THRSHLD_CHK_TMPLT_CODE) for validation.

Common Use Cases and Queries

This table is central to tax setup, reporting, and troubleshooting. Common use cases include validating the configuration of a new tax regime, generating a list of all active regimes for a specific country, or identifying the parent-child relationships between regimes. A typical query would join ZX_REGIMES_B to related descriptive tables like ZX_REGIMES_TL for translated names or to FND_TERRITORIES. For example, to list all regimes in the United States with their effective dates:

  • SELECT reg.tax_regime_code, tl.tax_regime_name, reg.country_code, reg.effective_from, reg.effective_to
  • FROM zx_regimes_b reg, zx_regimes_tl tl, fnd_territories terr
  • WHERE reg.tax_regime_code = tl.tax_regime_code
  • AND reg.country_code = terr.territory_code
  • AND terr.territory_short_name = 'US'
  • AND tl.language = USERENV('LANG');

Technical consultants also frequently query this table to trace data issues or understand the regime context of a specific tax (ZX_TAXES_B) or tax rule (ZX_RULES_B).

Related Objects

As indicated by its extensive foreign key relationships, ZX_REGIMES_B is the parent table for nearly all other major E-Business Tax entities. Key dependent tables include:

It also has important relationships to foundational tables like FND_TERRITORIES, FND_CURRENCIES, and ZX_PARTY_TAX_PROFILE (for tax authorities).

  • 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 , 

  • 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_REGIME_RELATIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIME_RELATIONS,  object_name:ZX_REGIME_RELATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores hierarchical relationships between tax regimes. ,  implementation_dba_data: ZX.ZX_REGIME_RELATIONS , 

  • Table: ZX_REGIME_RELATIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_REGIME_RELATIONS,  object_name:ZX_REGIME_RELATIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores hierarchical relationships between tax regimes. ,  implementation_dba_data: ZX.ZX_REGIME_RELATIONS , 

  • 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_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_REPORTING_TYPES_B 12.1.1

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

  • Table: ZX_REPORTING_TYPES_B 12.2.2

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

  • 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_RECOVERY_TYPES_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RECOVERY_TYPES_B,  object_name:ZX_RECOVERY_TYPES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. ,  implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B , 

  • 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_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_PARTY_TYPES 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TYPES,  object_name:ZX_PARTY_TYPES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores party types. ,  implementation_dba_data: ZX.ZX_PARTY_TYPES , 

  • Table: ZX_PARTY_TYPES 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_PARTY_TYPES,  object_name:ZX_PARTY_TYPES,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores party types. ,  implementation_dba_data: ZX.ZX_PARTY_TYPES , 

  • 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_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_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_RECOVERY_TYPES_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_RECOVERY_TYPES_B,  object_name:ZX_RECOVERY_TYPES_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores the recovery types. Each row stores a recovry type corresponding to a tax. ,  implementation_dba_data: ZX.ZX_RECOVERY_TYPES_B , 

  • 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_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_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_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_DET_FACTOR_TEMPL_B 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • 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_DET_FACTOR_TEMPL_B 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_B,  object_name:ZX_DET_FACTOR_TEMPL_B,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores templates for usage of determining factors. Each record represents one determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_B , 

  • Table: ZX_FORMULA_DETAILS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FORMULA_DETAILS,  object_name:ZX_FORMULA_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: For Taxable Basis formulas, this table stores compounding taxes or taxes for which the current tax is a surcharge. For Tax Calculation formulas, it stores taxes whose tax amounts must be added to/subtracted from the calculated tax amount. ,  implementation_dba_data: ZX.ZX_FORMULA_DETAILS , 

  • 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_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_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_FORMULA_DETAILS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_FORMULA_DETAILS,  object_name:ZX_FORMULA_DETAILS,  status:VALID,  product: ZX - E-Business Tax ,  description: For Taxable Basis formulas, this table stores compounding taxes or taxes for which the current tax is a surcharge. For Tax Calculation formulas, it stores taxes whose tax amounts must be added to/subtracted from the calculated tax amount. ,  implementation_dba_data: ZX.ZX_FORMULA_DETAILS , 

  • 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_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_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_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_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_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 ,