Search Results zx_condition_groups_vl




Overview
Explore in AI Chat

Overview

ZX_CONDITION_GROUPS_VL is a seeded, read-mostly view owned by the APPS schema in Oracle E-Business Suite, exposed primarily through the ETRM (E-Business Tax) module while being registered under the FND – Application Object Library product context. It presents the translatable, user-facing definition of tax condition groups, i.e., the named rule sets that determine when a given tax configuration — rate, jurisdiction, regime, or tax — applies to a transaction line.

Condition groups in E-Business Tax drive the determining factor logic used by the tax engine at runtime. Each condition group evaluates a weighted combination of determining factors (such as Ship-To country, product fiscal classification, or transaction business category) against operators and values to decide whether a tax is applicable, exempt, or excluded. The VL ("view language") designation indicates that the view joins the base table to its translation table and applies the session language (or the language passed through the FND language views) so that UI and report consumers see the condition group name and description in the appropriate language.

Because it is a view rather than a table, ZX_CONDITION_GROUPS_VL exposes no independent storage. It is intended for query, reporting, and integration extraction — never for direct DML. Inserts and updates to condition groups must be performed through the E-Business Tax setup UI or the supported PL/SQL APIs that operate on the underlying base tables.

Underlying Base Objects

Per documented ETRM metadata, the view references two underlying synonyms:

  • ZX_CONDITION_GROUPS_B — the base (non-translatable) table holding the operational definition of each condition group, including its ID, code, ledger and chart-of-accounts context, enabled flag, and the six determining-factor/operator/value slots.
  • ZX_CONDITION_GROUPS_TL — the translation table holding the language-specific condition group name and description keyed by CONDITION_GROUP_ID and LANGUAGE.

The VL view joins these on CONDITION_GROUP_ID and returns the B-table columns alongside the translated attributes. This B/TL pairing is the standard Oracle multi-language seed data pattern (as used across FND, AR, and ZX objects), ensuring that a single logical condition group is rendered once per session language.

Key Columns

The view exposes a wide projection of the base table. The principal columns include:

Common Use Cases and Queries

Typical consumers are tax analysts validating configuration, integration developers extracting tax setup, and DBAs diagnosing why a tax was or was not applied. Representative queries follow.

  • List all enabled condition groups for a jurisdiction: 
    SELECT condition_group_code, det_factor_templ_code, ledger_id
FROM   zx_condition_groups_vl
WHERE  country_code = 'US'
AND    enabled_flag = 'Y';
  • Inspect the determining-factor logic of a specific group: 
    SELECT condition_group_code,
       determining_factor_code1, operator1_code, alphanumeric_value1,
       determining_factor_code2, operator2_code, alphanumeric_value2
FROM   zx_condition_groups_vl
WHERE  condition_group_code = 'DEFAULT_TAX_RULE';
  • Find groups that exceed the stored six-slot capacity: 
    SELECT condition_group_id, condition_group_code
FROM   zx_condition_groups_vl
WHERE  more_than_max_cond_flag = 'Y';
  • Join to ZX_CONDITIONS_VL or ZX_TAXES_VL to trace which taxes leverage each condition group, supporting audit and configuration migration.

Because the view is read-only and language-aware, it is safe for reporting extracts, OBIEE/BI Publisher data models, and reconciliation scripts, provided queries are scoped by COUNTRY_CODE or CONDITION_GROUP_ID to avoid full-table scans in large tax repositories.