Results for “data_type10_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The ZX_CONDITION_GROUPS_B table is a core configuration object within the E-Business Tax (ZX) module of Oracle EBS 12.1.1 and 12.2.2. It stores the header definitions of condition groups — named sets of one or more determining factors and comparison operators that, when all conditions evaluate true, resolve to a single tax result. In the ETRM determination model, this table acts as the bridge between the individual condition rows stored in ZX_CONDITIONS and the outcome records stored in ZX_PROCESS_RESULTS. Each row in ZX_CONDITION_GROUPS_B represents a reusable rule "group" that tax configuration setups (tax regimes, taxes, tax statuses, rules) attach to via CONDITION_GROUP_CODE.

Because the table holds mostly descriptive and qualifying attributes keyed to a parent identifier, a Data Vault modeling heuristic suggests classifying it as satellite-leaning: it records state about a CONDITION_GROUP business key rather than originating its own independent hub or representing a many-to-many association. This aligns with its role as a detail/attribute carrier in the tax configuration schema.

Key Information Stored

The physical schema documented in ETRM 12.2.2 shows 130 columns, reflecting the table's ability to store up to ten parallel determining-factor predicates per group. The most significant columns are:

• CONDITION_GROUP_CODE — business identifier for the group, defined as the primary key component ZX_CONDITION_GROUPS_B_PK.
• CONDITION_GROUP_ID — internal surrogate key defined by the unique index ZX_CONDITION_GROUPS_B_U1, used as the referential anchor for child condition rows.
• COUNTRY_CODE — foreign key to FND_TERRITORIES, limiting the group to a territory jurisdiction.
• LEDGER_ID — foreign key associating the group with the ledger (legal entity / operating unit) context.
• CHART_OF_ACCOUNTS_ID — further scoping of the group to a chart of accounts, linking to GL_MGT_SEG_UPGRADE_H.
• DETERMINING_FACTOR_CODE1 … DETERMINING_FACTOR_CODE10 — the factors (e.g., ship-to party, product fiscal classification, transaction business category) evaluated by the group.
• OPERATOR1_CODE … OPERATOR10_CODE — the comparison operator applied to each factor value (equals, between, in, etc.).
• NUMERIC_VALUE1, DATE_VALUE1, ALPHANUMERIC_VALUE1, VALUE_LOW1, VALUE_HIGH1 (and 2–10) — the operand values for each factor, supporting numeric, date, and alphanumeric ranges.
• DATA_TYPE1_CODE … DATA_TYPE10_CODE — the data type driving which value column is populated.
• ENABLED_FLAG — indicates whether the group is active for determination processing.
• RECORD_TYPE_CODE — distinguishes record variants within the table.
• OBJECT_VERSION_NUMBER, CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns required for Oracle EBS concurrent/OLTP integrity.

Common Use Cases and Queries

Typical usage centers on configuration auditing, troubleshooting tax determination, and reporting.

• Locating a specific group and its ten predicates by code or ID:

  SELECT condition_group_code, enabled_flag, determining_factor_code1, operator1_code, numeric_value1
  FROM   zx_condition_groups_b
  WHERE  condition_group_code = :code;

• Finding all groups scoped to a given ledger or country:

  SELECT condition_group_code, country_code, ledger_id
  FROM   zx_condition_groups_b
  WHERE  ledger_id = :ledger_id;

• Resolving the full rule context by joining to the result and condition tables:

  SELECT cg.condition_group_code, pr.result_name, c.condition_group_code
  FROM   zx_condition_groups_b cg,
         zx_process_results pr,
         zx_conditions c
  WHERE  cg.condition_group_code = pr.condition_group_code
  AND    cg.condition_group_code = c.condition_group_code;

• Auditing which groups are disabled and may be retired during cleanup.

Related Objects

• ZX_CONDITIONS — child table referencing CONDITION_GROUP_CODE; holds the individual condition rows executed against this group.
• ZX_PROCESS_RESULTS — references CONDITION_GROUP_CODE; stores the result applied when a condition group evaluates true.
• FND_TERRITORIES — parent of COUNTRY_CODE, supplying territory jurisdiction data.
• GL_MGT_SEG_UPGRADE_H — parent of CHART_OF_ACCOUNTS_ID, contributing chart-of-accounts context.
• ZX_CONDITION_GROUPS_TL — the translation table for language-specific group names.
• ZX_REGIME_/ZX_RULE_ APIs — tax configuration APIs and concurrent programs that create and maintain condition groups programmatically.

Because both ZX_CONDITIONS and ZX_PROCESS_RESULTS depend on CONDITION_GROUP_CODE, restructure or deletion of group rows must be sequenced carefully to preserve referential integrity in tax determination.