Search Results determining_factor_cq_code




Overview
Explore in AI Chat

Overview

The ZX_DET_FACTOR_TEMPL_DTL table is a core data structure within the Oracle E-Business Tax (E-Business Tax) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It functions as the detail repository for determining factor templates, which are reusable rule components that define the conditions for tax calculation and determination. This table stores the specific set of determining factors (such as a ship-to location, product category, or transaction type) that collectively constitute a single template. Each record in this table represents one determining factor assigned to a template, enabling the modular and flexible configuration of complex tax rules.

Key Information Stored

The table's primary key structure defines its core data model. The key columns are DET_FACTOR_TEMPL_ID, DETERMINING_FACTOR_CLASS_CODE, DETERMINING_FACTOR_CQ_CODE, and DETERMINING_FACTOR_CODE. The DET_FACTOR_TEMPL_ID links the detail record to its parent template header in the ZX_DET_FACTOR_TEMPL_B table. The DETERMINING_FACTOR_CLASS_CODE and DETERMINING_FACTOR_CODE together identify the specific tax condition or attribute being defined, such as 'TAX_REGIME_CODE' or 'TAX'. The DETERMINING_FACTOR_CQ_CODE typically holds a classifier, such as a qualifier code, that provides additional context for the determining factor. This granular storage allows a single template to encapsulate multiple, precise conditions required for accurate tax determination.

Common Use Cases and Queries

This table is central to tax rule analysis, debugging, and impact assessment. A primary use case is tracing which specific determining factors are used within a particular template, which is essential for understanding why a specific tax rule was applied to a transaction. Common queries include listing all factors for a given template ID or identifying all templates that use a specific determining factor code. For example, to audit all factors in a template, one might execute:

  • SELECT determining_factor_class_code, determining_factor_cq_code, determining_factor_code FROM zx_det_factor_templ_dtl WHERE det_factor_templ_id = <TEMPLATE_ID>;

This data is also critical for reporting on tax rule coverage and for data migration or upgrade validation scripts that verify the integrity of configured tax determinants.

Related Objects

The ZX_DET_FACTOR_TEMPL_DTL table maintains defined relationships with other key E-Business Tax tables. Its primary foreign key relationship is with the ZX_DETERMINING_FACTORS_B table, which is the master repository for all valid determining factors. The join is performed on the columns DETERMINING_FACTOR_CLASS_CODE and DETERMINING_FACTOR_CODE, ensuring that only registered and valid factors can be assigned to a template. The table is a child of the ZX_DET_FACTOR_TEMPL_B table via the DET_FACTOR_TEMPL_ID column, which serves as the header-detail link. These relationships enforce data integrity and are fundamental to the E-Business Tax rule engine's operation.

  • Table: ZX_DET_FACTOR_TEMPL_DTL 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_DTL,  object_name:ZX_DET_FACTOR_TEMPL_DTL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents one determining factor in the determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_DTL , 

  • Table: ZX_CONDITIONS 12.1.1

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONDITIONS,  object_name:ZX_CONDITIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores a set of conditions for each condition group defined in ZX_CONDITION_GROUPS_B. Each record represents one condition in the condition group. ,  implementation_dba_data: ZX.ZX_CONDITIONS , 

  • Table: ZX_CONDITIONS 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_CONDITIONS,  object_name:ZX_CONDITIONS,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores a set of conditions for each condition group defined in ZX_CONDITION_GROUPS_B. Each record represents one condition in the condition group. ,  implementation_dba_data: ZX.ZX_CONDITIONS , 

  • Table: ZX_DET_FACTOR_TEMPL_DTL 12.2.2

    owner:ZX,  object_type:TABLE,  fnd_design_data:ZX.ZX_DET_FACTOR_TEMPL_DTL,  object_name:ZX_DET_FACTOR_TEMPL_DTL,  status:VALID,  product: ZX - E-Business Tax ,  description: This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents one determining factor in the determining factor template. ,  implementation_dba_data: ZX.ZX_DET_FACTOR_TEMPL_DTL ,