Search Results zx_regimes_b

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:

• ZX_TAXES_B: Stores individual taxes belonging to a regime.
• ZX_RULES_B, ZX_STATUS_B, ZX_REPORTING_TYPES_B: Contain rules, statuses, and reporting types defined at the regime level.
• ZX_REGISTRATIONS: Holds party tax registrations under a specific regime.
• ZX_LINES and ZX_LINES_SUMMARY: Reference the regime on transactional tax lines.
• ZX_REGIME_RELATIONS and ZX_REGIMES_USAGES: Manage regime hierarchies and usage assignments.

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