Search Results zx_process_results

Overview

The ZX_PROCESS_RESULTS table is a core transactional repository within the Oracle E-Business Tax (ZX) module for Oracle EBS 12.1.1 and 12.2.2. It functions as the central ledger for storing the detailed outcomes of tax rule evaluations performed by the E-Business Tax engine. Each record in this table captures the process result for the evaluation of a specific condition group within a tax rule during a transaction's tax calculation. Its primary role is to persist the logical conclusions of rule processing, which are then referenced to determine the final tax lines, rates, applicability, and other tax attributes for a transaction line. This persistence is critical for audit trails, reporting, and ensuring consistent tax determination across complex, multi-step rule evaluations.

Key Information Stored

While the provided metadata does not list individual columns, the primary and foreign key relationships define its critical data elements. The table's primary key is RESULT_ID, a unique identifier for each process result record. Essential foreign key columns establish the context of the evaluation: TAX_RULE_ID links to the specific rule (ZX_RULES_B) that was processed, and CONDITION_GROUP_CODE identifies the particular condition group (ZX_CONDITION_GROUPS_B) within that rule whose outcome is stored. The CONTENT_OWNER_ID column links to the party tax profile (ZX_PARTY_TAX_PROFILE) that owns the rule content. The table likely contains columns indicating the result status (e.g., 'PASS', 'FAIL', a specific value), evaluation timestamps, and other attributes detailing the outcome of the condition group logic.

Common Use Cases and Queries

The primary use case is debugging and auditing the tax determination logic for a given transaction. Analysts can trace why a specific tax line was created by joining ZX_PROCESS_RESULTS to transaction tax lines (ZX_LINES) and the related rule setup tables. A common query pattern involves identifying all rule evaluations for a problematic invoice line to see which rules passed or failed.

SELECT zpr.result_id, zpr.tax_rule_id, zr.rule_code, zpr.condition_group_code, zl.tax_line_id
FROM zx_process_results zpr
JOIN zx_lines zl ON zpr.result_id = zl.calc_result_id
JOIN zx_rules_b zr ON zpr.tax_rule_id = zr.tax_rule_id
WHERE zl.trx_id = :p_trx_id
AND zl.trx_line_id = :p_trx_line_id
ORDER BY zpr.tax_rule_id;

Another critical use is performance analysis, where a high volume of result records for a single transaction may indicate inefficient rule configuration or excessive rule evaluations.

Related Objects

ZX_PROCESS_RESULTS is a central hub with extensive foreign key relationships, primarily with the ZX_LINES table. As documented, numerous columns in ZX_LINES reference specific process results for different tax determination phases, including:

ZX_LINES.CALC_RESULT_ID, .TAX_APPLICABILITY_RESULT_ID, .RATE_RESULT_ID, .BASIS_RESULT_ID
ZX_LINES.PLACE_OF_SUPPLY_RESULT_ID, .TAX_DATE_RULE_ID, .TAX_REG_NUM_DET_RESULT_ID
ZX_LINES.EVAL_EXMPT_RESULT_ID, .EVAL_EXCPT_RESULT_ID, .DIRECT_RATE_RESULT_ID, .STATUS_RESULT_ID, .THRESH_RESULT_ID

It also has a direct foreign key relationship to ZX_REC_NREC_DIST via APPLICABILITY_RESULT_ID for recovery/non-recovery distributions. The table is fundamentally linked to the rule setup infrastructure through foreign keys to ZX_RULES_B (TAX_RULE_ID), ZX_CONDITION_GROUPS_B (CONDITION_GROUP_CODE), and ZX_PARTY_TAX_PROFILE (CONTENT_OWNER_ID).

Table: ZX_PROCESS_RESULTS 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PROCESS_RESULTS, object_name:ZX_PROCESS_RESULTS, status:VALID, product: ZX - E-Business Tax , description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. , implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,
Table: ZX_PROCESS_RESULTS 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PROCESS_RESULTS, object_name:ZX_PROCESS_RESULTS, status:VALID, product: ZX - E-Business Tax , description: This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition group in a tax rule. , implementation_dba_data: ZX.ZX_PROCESS_RESULTS ,
Table: ZX_LINES 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES, object_name:ZX_LINES, status:VALID, product: ZX - E-Business Tax , description: This table stores detail tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES ,
Table: ZX_LINES 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_LINES, object_name:ZX_LINES, status:VALID, product: ZX - E-Business Tax , description: This table stores detail tax lines for transactions of multiple event classes. , implementation_dba_data: ZX.ZX_LINES ,
Table: ZX_CONDITION_GROUPS_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_CONDITION_GROUPS_B, object_name:ZX_CONDITION_GROUPS_B, status:VALID, product: ZX - E-Business Tax , description: This table associates the multiple conditions defined in Conditions to a Result. , implementation_dba_data: ZX.ZX_CONDITION_GROUPS_B ,
Lookup Type: ZX_REPORTING_TABLE_USE 12.1.1
product: ZX - E-Business Tax , meaning: Reporting Types Table uses ,
Table: ZX_CONDITION_GROUPS_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_CONDITION_GROUPS_B, object_name:ZX_CONDITION_GROUPS_B, status:VALID, product: ZX - E-Business Tax , description: This table associates the multiple conditions defined in Conditions to a Result. , implementation_dba_data: ZX.ZX_CONDITION_GROUPS_B ,
Lookup Type: ZX_REPORTING_TABLE_USE 12.2.2
product: ZX - E-Business Tax , meaning: Reporting Types Table uses ,
Table: ZX_RULES_B 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RULES_B, object_name:ZX_RULES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. , implementation_dba_data: ZX.ZX_RULES_B ,
Table: ZX_RULES_B 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_RULES_B, object_name:ZX_RULES_B, status:VALID, product: ZX - E-Business Tax , description: This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for a specific tax, configuration owner and tax detemination process. , implementation_dba_data: ZX.ZX_RULES_B ,
Table: ZX_REC_NREC_DIST 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REC_NREC_DIST, object_name:ZX_REC_NREC_DIST, status:VALID, product: ZX - E-Business Tax , description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. , implementation_dba_data: ZX.ZX_REC_NREC_DIST ,
Table: ZX_REC_NREC_DIST 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_REC_NREC_DIST, object_name:ZX_REC_NREC_DIST, status:VALID, product: ZX - E-Business Tax , description: This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line. , implementation_dba_data: ZX.ZX_REC_NREC_DIST ,
Table: ZX_PARTY_TAX_PROFILE 12.1.1
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE, object_name:ZX_PARTY_TAX_PROFILE, status:VALID, product: ZX - E-Business Tax , description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. , implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,
Table: ZX_PARTY_TAX_PROFILE 12.2.2
owner:ZX, object_type:TABLE, fnd_design_data:ZX.ZX_PARTY_TAX_PROFILE, object_name:ZX_PARTY_TAX_PROFILE, status:VALID, product: ZX - E-Business Tax , description: This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal establishments, operating units and tax authorities. , implementation_dba_data: ZX.ZX_PARTY_TAX_PROFILE ,