Results for “result_api”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_PROCESS_RESULTS is a core transaction table within the Oracle E-Business Tax (ZX) module, owned by the ZX schema. It stores the outcome of tax rule evaluation during tax determination and tax calculation processing in Oracle EBS 12.1.1 and 12.2.2. Each row captures the process result for the evaluation of a specific condition group within a tax rule, recording whether the conditions evaluated to true or false and, where applicable, the numeric or alphanumeric values derived from that evaluation.

Within the E-Business Tax engine, this table acts as the persistent record of rule engine decisions. When a tax line is processed, the rules engine iterates through condition groups defined in ZX_CONDITION_GROUPS_B, evaluates each against the transaction context, and writes the outcome into ZX_PROCESS_RESULTS. Downstream consumers such as ZX_LINES and ZX_REC_NREC_DIST reference those outcome rows to determine tax applicability, rates, bases, thresholds, exemptions, exceptions, tax dates, and recovery/non-recoverable distributions.

From a heuristic Data Vault modeling perspective, ZX_PROCESS_RESULTS classifies as a hub. Its surrogate primary key, RESULT_ID, is referenced by a wide array of foreign key columns across ZX_LINES and ZX_REC_NREC_DIST, indicating it functions as a central business entity around which dependent evaluation results are linked.

Key Information Stored

The documented schema contains 36 columns. The surrogate primary key ZX_PROCESS_RESULTS_PK is built on RESULT_ID, which uniquely identifies each evaluation outcome. A second unique index, ZX_PROCESS_RESULTS_U2, covers TAX_RULE_ID, CONDITION_GROUP_CODE, ENABLED_FLAG, PRIORITY, TAX_STATUS_CODE, CONDITION_SET_ID, and EXCEPTION_SET_ID, serving as the business-key candidate for the rule/condition-group combination.

• RESULT_ID — surrogate primary key identifying each process result record.
• TAX_RULE_ID — foreign key to ZX_RULES_B, identifying the tax rule being evaluated.
• CONDITION_GROUP_CODE / CONDITION_GROUP_ID — identifier of the condition group within the rule whose evaluation produced this result.
• RESULT_TYPE_CODE / RESULT_API — classify the type of result and the API that produced it.
• NUMERIC_RESULT / ALPHANUMERIC_RESULT / STATUS_RESULT / RATE_RESULT — the actual evaluated values returned by the rule engine.
• TAX_STATUS_CODE — the tax status (for example taxable, exempt, zero-rated) determined by the evaluation.
• ENABLED_FLAG, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG — control flags governing downstream behavior.
• CONDITION_SET_ID / EXCEPTION_SET_ID — links to condition and exception sets applied during evaluation; EXCEPTION_SET_ID references BOM_EXCEPTION_SETS.
• CONTENT_OWNER_ID — foreign key to ZX_PARTY_TAX_PROFILE, scoping the result to a configuration owner.
• LEGAL_MESSAGE_CODE — message associated with the evaluation outcome.
• MIN_TAX_AMT, MAX_TAX_AMT, MIN_TAXABLE_BASIS, MAX_TAXABLE_BASIS, MIN_TAX_RATE, MAX_TAX_RATE — threshold bounds applied to amounts, bases, and rates.
• OBJECT_VERSION_NUMBER — optimistic locking column for concurrent updates.

Common Use Cases and Queries

Typical usage centers on tax determination diagnostics and reporting. A common pattern is to retrieve all results for a tax rule and condition group to inspect why a line was taxed or exempted:

• Join ZX_PROCESS_RESULTS to ZX_LINES on columns such as CALC_RESULT_ID, RATE_RESULT_ID, BASIS_RESULT_ID, TAX_APPLICABILITY_RESULT_ID, and STATUS_RESULT_ID to reconstruct how a specific tax line was derived.
• Filter by RESULT_TYPE_CODE and TAX_STATUS_CODE to produce exception reports identifying exempt or zero-rated determinations.
• Audit threshold behavior using MIN_TAX_AMT, MAX_TAX_AMT, MIN_TAX_RATE, and MAX_TAX_RATE alongside NUMERIC_RESULT and RATE_RESULT.
• Reconcile recovery by joining ZX_PROCESS_RESULTS to ZX_REC_NREC_DIST on APPLICABILITY_RESULT_ID.
• Identify configuration owners via CONTENT_OWNER_ID when troubleshooting multi-organization tax setups.

A representative query pattern selects RESULT_ID, TAX_RULE_ID, CONDITION_GROUP_CODE, TAX_STATUS_CODE, and RATE_RESULT from ZX_PROCESS_RESULTS where TAX_RULE_ID is bound to a specific rule and ENABLED_FLAG is in an active state.

Related Objects

• ZX_LINES — references ZX_PROCESS_RESULTS through numerous result columns including CALC_RESULT_ID, RATE_RESULT_ID, BASIS_RESULT_ID, THRESH_RESULT_ID, RATE_RESULT_ID, STATUS_RESULT_ID, TAX_APPLICABILITY_RESULT_ID, TAX_DATE_RULE_ID, and others.
• ZX_REC_NREC_DIST — links via APPLICABILITY_RESULT_ID for recoverable and non-recoverable tax distributions.
• ZX_RULES_B — parent tax rule referenced by TAX_RULE_ID.
• ZX_CONDITION_GROUPS_B — parent condition group referenced by CONDITION_GROUP_CODE.
• ZX_PARTY_TAX_PROFILE — configuration owner referenced by CONTENT_OWNER_ID.
• BOM_EXCEPTION_SETS — referenced by EXCEPTION_SET_ID for exception set definitions.