Search Results ar_tax_condition_actions_pk

Overview

The AR_TAX_CONDITION_ACTIONS_ALL table is a core data object within the Oracle E-Business Suite Receivables (AR) module, specifically supporting the tax engine in releases 12.1.1 and 12.2.2. It represents the specific actions that are executed when a defined tax condition is met within a Tax Condition Set. These sets are part of the flexible tax determination logic used to calculate and apply taxes on transactions. The table's role is to store the actionable outcomes—such as applying a specific tax rate, jurisdiction, or exemption—linked to a tax condition, thereby translating conditional logic into concrete tax calculations for invoices, credit memos, and other receivables transactions.

Key Information Stored

The table stores the linkage between a tax condition and its resulting actions, with the primary key enforcing uniqueness on a combination of four columns. The most critical columns include TAX_CONDITION_ID, which is the foreign key linking to the parent condition, and TAX_CONDITION_ACTION_ID, which uniquely identifies a specific action instance. The TAX_CONDITION_ACTION_TYPE column defines the nature of the action (e.g., 'TAX_CODE', 'TAX_EXEMPTION'). The DISPLAY_ORDER column dictates the sequence in which multiple actions for a single condition are processed. While the provided metadata does not list all columns, typical related attributes stored would include action-specific parameters, such as a tax code identifier or exemption reason code, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, etc.).

Common Use Cases and Queries

A primary use case is troubleshooting tax calculation errors by examining the actions tied to a specific condition. For instance, if a transaction is not being taxed as expected, a consultant might query this table to verify the actions configured for the relevant TAX_CONDITION_ID. Common SQL patterns include joining to the parent conditions table (AR_TAX_CONDITIONS) to get a full view of the rule logic.

• Sample Query to List Actions for a Condition:
  SELECT tax_condition_id, tax_condition_action_type, display_order
FROM ar_tax_condition_actions_all
WHERE tax_condition_id = :p_condition_id
ORDER BY display_order;
• Reporting Use Case: Generating a functional specification document for all tax condition sets, detailing each condition's associated actions and their execution order for audit or migration purposes.

Related Objects

This table is centrally linked to the tax condition definition framework. Its primary relationship, as defined by its composite primary key, is as a child to the AR_TAX_CONDITIONS table via the TAX_CONDITION_ID column. The actions defined here are invoked by the tax engine's processing logic, which is often encapsulated within packages like AR_TAX_ENGINE or AR_TAX_CALC_PVT. While the provided metadata specifies the primary key constraint (AR_TAX_CONDITION_ACTIONS_PK), it strongly implies a foreign key relationship where TAX_CONDITION_ID references a corresponding ID in the AR_TAX_CONDITIONS table. Other related objects would include AR_TAX_CODES_ALL or AR_TAX_EXEMPTIONS if the action type applies a specific code or exemption.