Search Results zx_determining_factors_b




Overview
Explore in AI Chat

Overview

The ZX_DETERMINING_FACTORS_B table is a core repository within the Oracle E-Business Tax (ZX) module for Oracle EBS 12.1.1 and 12.2.2. It serves as the master definition table for determining factors, which are the individual conditions or criteria used to construct tax rules. These factors are the fundamental building blocks that allow the system to evaluate complex tax scenarios, such as determining the applicable tax rate, tax status, or tax jurisdiction based on transactional attributes like product category, customer location, or ship-from address. The table's role is to provide a centralized, validated list of all available factors that can be referenced when configuring the E-Business Tax engine's rule-based logic.

Key Information Stored

The table stores metadata that defines each determining factor. Its structure is anchored by a composite primary key consisting of DETERMINING_FACTOR_CLASS_CODE and DETERMINING_FACTOR_CODE. The class code categorizes the factor (e.g., 'TAXABLE_BASIS', 'PLACE_OF_SUPPLY'), while the code uniquely identifies the specific factor within that class (e.g., 'TRANSACTION_BUSINESS_CATEGORY'). A critical column is VALUE_SET, which is a foreign key to FND_FLEX_VALUE_SETS. This relationship constrains the valid values a user can select for this factor during rule setup, ensuring data integrity. For example, a determining factor for "Transaction Business Category" would be linked to a value set containing specific categories like 'STANDARD', 'EXEMPT', or 'ZERO_RATED'.

Common Use Cases and Queries

Primary use cases involve the administration and auditing of the tax rule configuration. A common query retrieves all determining factors within a specific class to understand the available conditions for a rule type. For instance, to audit all factors related to tax calculation and their associated validation value sets, one might use:

  • SELECT determining_factor_class_code, determining_factor_code, value_set FROM zx_determining_factors_b WHERE determining_factor_class_code LIKE 'TAX%' ORDER BY 1, 2;

Another critical scenario is troubleshooting rule resolution. Developers may query this table to verify the existence and definition of a factor referenced in a non-functioning tax rule, ensuring it is correctly defined and linked to a valid value set. Reporting use cases include generating a master list of all configurable conditions for documentation or compliance purposes.

Related Objects

ZX_DETERMINING_FACTORS_B is central to the E-Business Tax data model. It has a direct foreign key relationship to FND_FLEX_VALUE_SETS via the VALUE_SET column, linking tax logic to the application's flexible validation framework. Furthermore, it is referenced by the ZX_DET_FACTOR_TEMPL_DTL table through a foreign key on the primary key columns. This relationship is crucial, as ZX_DET_FACTOR_TEMPL_DTL uses the master definitions from ZX_DETERMINING_FACTORS_B to construct the detailed conditions within tax rule templates. Consequently, this table underpins the configuration stored in higher-level rule definition tables, such as those for tax rules (ZX_RULES_B) and rule details.