Search Results zx_condition_groups_b




Overview
Explore in AI Chat

Overview

The ZX_CONDITION_GROUPS_B table is a core configuration entity within the Oracle E-Business Tax (E-Business Tax) module for releases 12.1.1 and 12.2.2. It serves as a master definition table for condition groups, which are logical sets of one or more tax determination conditions. Its primary role is to act as a central linking mechanism, associating multiple individual conditions (defined in ZX_CONDITIONS) to a single tax determination result (defined in ZX_PROCESS_RESULTS). This structure is fundamental to the rule-based tax engine, enabling complex tax logic where a result is contingent upon the evaluation of several criteria.

Key Information Stored

The table's structure is designed to uniquely identify and describe a condition group within a specific legal and financial context. The primary key, CONDITION_GROUP_CODE, is the unique identifier for the group. Critical contextual columns include COUNTRY_CODE, which references FND_TERRITORIES to define the applicable country, and LEDGER_ID, which scopes the group to a specific financial ledger. Other supporting columns typically include metadata such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE for auditing, along with descriptive fields like TAX_REGIME_CODE and TAX that may further qualify the group's applicability.

Common Use Cases and Queries

This table is primarily accessed during the design and analysis of tax determination setups. A common use case is tracing the complete logic path for a tax calculation. For instance, to identify all conditions belonging to a specific group, one would join ZX_CONDITION_GROUPS_B to ZX_CONDITIONS. Conversely, to find which result a condition group drives, a join to ZX_PROCESS_RESULTS is used. A typical diagnostic query might be:

  • SELECT cg.condition_group_code, c.condition_code, pr.result_code
  • FROM zx_condition_groups_b cg
  • JOIN zx_conditions c ON cg.condition_group_code = c.condition_group_code
  • LEFT JOIN zx_process_results pr ON cg.condition_group_code = pr.condition_group_code
  • WHERE cg.country_code = 'US';

This pattern is essential for troubleshooting tax determination errors or documenting tax rule setups.

Related Objects

The ZX_CONDITION_GROUPS_B table is central to the E-Business Tax data model, with defined relationships to several key tables.

  • Referenced Foreign Keys (This table references):
    • FND_TERRITORIES: Via ZX_CONDITION_GROUPS_B.COUNTRY_CODE. Establishes the country territory for the condition group.
    • % (Ledger Table): Via ZX_CONDITION_GROUPS_B.LEDGER_ID. Links the condition group to a specific general ledger.
  • Referencing Foreign Keys (Tables that reference this table):
    • ZX_CONDITIONS: Via ZX_CONDITIONS.CONDITION_GROUP_CODE. This is the primary relationship where individual tax conditions are assigned to a group.
    • ZX_PROCESS_RESULTS: Via ZX_PROCESS_RESULTS.CONDITION_GROUP_CODE. This links the evaluated condition group to its resulting tax determination outcome.