Search Results zx_process_results




Overview
Explore in AI Chat

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:

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).