Search Results zx_regime_relations




Overview
Explore in AI Chat

Overview

The ZX_REGIME_RELATIONS table is a core data object within the Oracle E-Business Tax (ZX) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the central repository for defining and storing the hierarchical relationships between different tax regimes configured within the application. A tax regime represents a distinct body of tax law, such as a country's federal VAT or a state's sales tax. This table enables the modeling of complex tax structures where one regime may be subordinate to another, such as a state-level regime existing within a federal national regime. This hierarchy is fundamental for accurate tax determination, reporting, and compliance, as it allows the system to understand the context and precedence of overlapping tax rules.

Key Information Stored

The table's primary function is to link a child tax regime to its parent. Its structure is defined by a composite primary key consisting of two critical columns: REGIME_CODE and PARENT_REGIME_CODE. The REGIME_CODE column stores the unique identifier for the subordinate or child tax regime. The PARENT_REGIME_CODE column stores the unique identifier for the superior or parent regime under which the child regime operates. This simple yet powerful pair of columns establishes the parent-child link. Both columns are foreign keys referencing the ZX_REGIMES_B table, ensuring data integrity by only allowing relationships between valid, defined tax regimes.

Common Use Cases and Queries

The primary use case is navigating the tax regime hierarchy for configuration and reporting. Administrators may query this table to audit the established regime relationships. A common reporting requirement is to list all child regimes for a given parent, such as finding all state sales tax regimes within a country. This can be achieved with a simple SQL join:

  • SELECT rel.regime_code, rel.parent_regime_code, reg.regime_name FROM zx_regime_relations rel, zx_regimes_b reg WHERE rel.regime_code = reg.regime_code AND rel.parent_regime_code = 'US_FED';

Conversely, finding the parent for a specific regime is essential for understanding its full legal context. The hierarchy defined here is also critical during the tax calculation engine's runtime, where the system traverses these relationships to identify all applicable regimes for a transaction based on its geographical and legal attributes.

Related Objects

The ZX_REGIME_RELATIONS table has direct, documented dependencies within the E-Business Tax schema. Its two foreign key relationships are both with the master tax regime definition table:

  • ZX_REGIMES_B: The ZX_REGIME_RELATIONS.PARENT_REGIME_CODE column references ZX_REGIMES_B.
  • ZX_REGIMES_B: The ZX_REGIME_RELATIONS.REGIME_CODE column references ZX_REGIMES_B.

This design ensures that every relationship recorded is between two valid, pre-defined regimes. The table is primarily accessed and managed through the E-Business Tax user interface and supporting APIs, which enforce business logic on top of these fundamental data relationships.