Search Results zx_regimes_b




The ZX_REGIMES_B table is a fundamental component of Oracle E-Business Suite (EBS) Tax Engine, specifically within Release 12.1.1 or 12.2.2. It serves as the primary repository for tax regime definitions, which are critical for configuring and managing tax rules across different jurisdictions. This table stores metadata about tax regimes, including their applicability, effective dates, and relationships with other tax components. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

1. Table Purpose and Functional Role

The ZX_REGIMES_B table is part of the Oracle E-Business Tax (EBTax) module, which centralizes tax calculation and compliance. It defines tax regimes—logical groupings of tax jurisdictions (e.g., country, state, or local tax authorities). Each regime represents a distinct tax authority with its own rules, rates, and reporting requirements. Key functionalities include:
  • Tax Regime Definition: Stores attributes like regime code, name, effective dates, and geographical scope.
  • Hierarchy Management: Links regimes to higher-level jurisdictions (e.g., a state regime under a country).
  • Integration: Serves as a reference for other EBTax tables (ZX_RATES_B, ZX_RULES_B) to enforce tax calculations.

2. Key Columns and Structure

The table's columns are categorized into:
  • Identifier Columns:
    • REGIME_ID: Primary key, uniquely identifying each regime.
    • REGIME_CODE: Unique abbreviation (e.g., "US_SALES" for U.S. sales tax).
  • Descriptive Columns:
    • REGIME_NAME: Human-readable name (e.g., "United States Sales Tax").
    • DESCRIPTION: Detailed notes about the regime.
  • Control Columns:
    • EFFECTIVE_FROM and EFFECTIVE_TO: Date ranges for regime validity.
    • ENABLED_FLAG: "Y" or "N" to activate/deactivate the regime.
  • Geographical Columns:
    • COUNTRY_CODE: ISO country code (e.g., "US" for United States).
    • STATE_CODE: Applicable for sub-national regimes.

3. Integration with Oracle EBS Modules

The ZX_REGIMES_B table interacts with:
  • EBTax Engine: Provides the foundation for tax rule processing in ZX_RULES_B and rate determination in ZX_RATES_B.
  • Financials (AP/AR): Tax regimes are referenced during invoice validation and payment processing.
  • Reporting: Used in tax reports (e.g., VAT returns) to filter data by jurisdiction.

4. Technical Considerations

  • Indexes: Typically indexed on REGIME_ID, REGIME_CODE, and COUNTRY_CODE for performance.
  • Audit Columns: Includes CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for compliance.
  • API Dependencies: Managed via Oracle's Tax APIs (e.g., ZX_API_PUB) to ensure data integrity.

5. Customization and Extensions

While Oracle provides seeded regimes, customers can:
  • Add custom regimes for unique tax jurisdictions.
  • Extend the table via descriptive flexfields (DFFs) for additional attributes.

Conclusion

The ZX_REGIMES_B table is a cornerstone of Oracle EBS's tax functionality, enabling precise tax configuration and compliance. Its design supports multi-jurisdictional tax management, ensuring accurate calculations and reporting. Understanding its structure and relationships is essential for implementing or customizing tax solutions in Oracle EBS 12.1.1 or 12.2.2.

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

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