Results for “tax_condition_action_code”

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

Overview

AR_TAX_CONDITION_ACTIONS_ALL is a Receivables (AR) module table that stores the actions performed by Tax Condition Sets within the Oracle E-Business Suite tax determination framework. Tax condition sets define the rules that govern how tax is applied to transactions, and this table records the individual actions (such as setting a tax rate, applying a tax regime, or overriding default behavior) that each condition triggers when its criteria are satisfied. The table resides in the AR schema and is classified as VALID in both Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined foreign-key metadata classifies this object as standalone. This is a heuristic classification rather than a declared constraint, but it suggests the table behaves less like a classic transactional hub-and-link structure and more like a configuration/reference satellite in practical modeling terms. The table carries its own surrogate key and organizational context (ORG_ID), making it multi-org aware, while its functional content is descriptive configuration rather than high-volume transactional data.

Key Information Stored

The table documents 49 columns in the 12.2.2 physical schema. The most significant columns for functional and integration purposes include:

• TAX_CONDITION_ACTION_ID — The primary surrogate identifier for an action row. A unique index, AR_TAX_CONDITION_ACTIONS_U1, is defined on this column, making it the strongest business-key candidate.
• TAX_CONDITION_ID — Foreign reference linking the action to its parent tax condition set, establishing the configuration hierarchy.
• TAX_CONDITION_ACTION_TYPE — The category of action being performed when the condition evaluates true. Part of the composite primary key AR_TAX_CONDITION_ACTIONS_PK.
• TAX_CONDITION_ACTION_CODE — The coded identifier of the specific action to execute.
• TAX_CONDITION_ACTION_VALUE — The value the action assigns or applies, such as a rate or regime code.
• DISPLAY_ORDER — Sequencing used to control the evaluation order of multiple actions within a condition; also part of the composite PK.
• ORG_ID — Operating unit context, enabling multi-org security and segregation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — Descriptive flexfield (DFF) columns for extensibility.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1–20 — Global descriptive flexfield columns reserved for localization and country-specific extensions.

The composite primary key AR_TAX_CONDITION_ACTIONS_PK spans TAX_CONDITION_ACTION_ID, TAX_CONDITION_ID, TAX_CONDITION_ACTION_TYPE, and DISPLAY_ORDER. The standalone unique index on TAX_CONDITION_ACTION_ID effectively makes that single column the row-level business key, while the remaining columns contribute to logical grouping and sequencing.

Common Use Cases and Queries

Typical uses include auditing tax configuration, diagnosing why tax was calculated a certain way, and migrating or comparing setups between environments. A representative query retrieves all actions for a given condition set in execution order:

• SELECT TAX_CONDITION_ACTION_ID, TAX_CONDITION_ACTION_TYPE, TAX_CONDITION_ACTION_CODE, TAX_CONDITION_ACTION_VALUE, DISPLAY_ORDER FROM AR.AR_TAX_CONDITION_ACTIONS_ALL WHERE TAX_CONDITION_ID = :p_condition_id AND ORG_ID = :p_org_id ORDER BY DISPLAY_ORDER;
• Reporting: trace which action codes drive specific tax outcomes for reconciliation of tax amounts on invoices.
• Setup validation: confirm that no condition set is missing an expected action type or value before a go-live.
• Localization review: inspect GLOBAL_ATTRIBUTE values to determine whether country-specific logic alters default behavior.

Related Objects

The most significant related objects and the join paths inferred from the documented metadata include:

• AR_TAX_CONDITIONS_ALL — Parent of this table; joined on TAX_CONDITION_ID to resolve the owning condition set.
• AR_TAX_CONDITION_SETS_ALL — Groups the condition sets that contain these actions.
• AR_TAX_CONDITIONS_PK / indexes — Constraint and index dependencies supporting referential access.
• ZX (Tax) regime and rate tables — Resolve TAX_CONDITION_ACTION_VALUE codes against the underlying tax regime, rate, and jurisdiction definitions.
• AR_TAX_CONDITION_ACTIONS_U1 — Unique index providing direct row access via TAX_CONDITION_ACTION_ID.

Because the metadata classifies the object as standalone with no declared foreign keys, joins to parent and tax-regime tables are enforced at the application layer rather than the database constraint layer, which is a key consideration when designing integration or data-migration logic.