Search Results ax_conditions

Overview

AX_CONDITIONS is a transaction table in the AX (Global Accounting Engine) product family of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores the condition definitions that drive distribution plan structures and distribution headers, effectively acting as the rule repository that determines how Global Accounting Engine transformations are applied. Each row captures a single condition — a comparison expression composed of a logic operator, a left operand, a comparison operator, and a right operand — that is evaluated during the execution of a distribution plan.

The table is owned by the AX schema and is classified as a link entity in a heuristic Data Vault modeling sense. This classification reflects its structural role: AX_CONDITIONS does not represent an independent business concept but rather associates condition metadata with the structures and headers that consume it, carrying foreign key references back to AX_STRUCTURES and AX_DISTRIB_HEADERS. Practitioners designing downstream models should treat it as a bridge between distribution definitions and the rule logic applied to them.

Key Information Stored

The physical schema documents 21 columns. The most significant are summarized below.

CONDITION_ID — the surrogate primary key, enforced by AX_CONDITIONS_PK. Also carries a unique index (AX_CONDITIONS_U1), making it a documented business-key candidate.
CONDITION_NUMBER — the user-facing identifier for the condition, used for ordering and reference within the distribution definition.
SET_OF_BOOKS_ID — the ledger context for the condition; participates in the foreign keys to both AX_STRUCTURES and AX_DISTRIB_HEADERS.
APPLICATION_ID — the owning application context; also part of those same foreign keys.
TRANSLATION_SCHEME — the translation scheme under which the condition operates, again part of the composite foreign keys.
HEADER_NUMBER — links the condition to a specific distribution header (AX_DISTRIB_HEADERS).
PLAN_NAME, STRUCTURE_TYPE, STRUCTURE_NUMBER — identify the distribution plan and structure (AX_STRUCTURES) to which the condition belongs.
LOGIC_OPERATOR — the boolean connector (for example AND/OR) used when multiple conditions are chained.
LEFT_TABLE, LEFT_COLUMN — the source table and column for the left-hand operand of the comparison.
COMPARISON_OPERATOR — the relational operator (=, >, <, etc.) applied between operands.
RIGHT_OPERAND_TYPE, RIGHT_OP_COLUMN_VALUE, RIGHT_OP_TABLE — define the right-hand side, which may be a literal value or a column reference from another table.
Standard audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical queries retrieve all conditions attached to a given distribution structure or header, or audit the rule logic driving an account transformation. A representative join pattern follows:

List conditions for a structure: SELECT c.condition_number, c.logic_operator, c.left_table, c.left_column, c.comparison_operator, c.right_op_column_value FROM ax.ax_conditions c WHERE c.set_of_books_id = :sob AND c.application_id = :app AND c.translation_scheme = :scheme AND c.plan_name = :plan AND c.structure_number = :struct;
List conditions for a distribution header: filter the same table by SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, and HEADER_NUMBER.
Audit reporting: join AX_CONDITIONS to AX_STRUCTURES and AX_DISTRIB_HEADERS to produce a complete picture of plan logic for a given ledger.

Because the table mixes literal and column-based operands, reporting should account for RIGHT_OPERAND_TYPE when interpreting results.

Related Objects

AX_STRUCTURES — parent structure definition; joined via SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, PLAN_NAME, STRUCTURE_TYPE, and STRUCTURE_NUMBER.
AX_DISTRIB_HEADERS — parent distribution header; joined via SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, and HEADER_NUMBER.
AX_CONDITIONS_PK and AX_CONDITIONS_U1 — the primary and unique indexes on CONDITION_ID.
Distribution plan and translation scheme definition tables, which provide the PLAN_NAME and TRANSLATION_SCHEME reference values consumed here.

Table: AX_CONDITIONS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_CONDITIONS, object_name:AX_CONDITIONS, status:VALID, product: AX - Global Accounting Engine , description: Conditions used by distribution plan structures or distribution headers , implementation_dba_data: AX.AX_CONDITIONS ,
Table: AX_CONDITIONS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_CONDITIONS, object_name:AX_CONDITIONS, status:VALID, product: AX - Global Accounting Engine , description: Conditions used by distribution plan structures or distribution headers , implementation_dba_data: AX.AX_CONDITIONS ,
TABLE: AX.AX_CONDITIONS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_CONDITIONS, object_name:AX_CONDITIONS, status:VALID,
TABLE: AX.AX_CONDITIONS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_CONDITIONS, object_name:AX_CONDITIONS, status:VALID,
TABLE: AX.AX_STRUCTURES 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_STRUCTURES, object_name:AX_STRUCTURES, status:VALID,
TABLE: AX.AX_DISTRIB_HEADERS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_DISTRIB_HEADERS, object_name:AX_DISTRIB_HEADERS, status:VALID,
TABLE: AX.AX_DISTRIB_HEADERS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_DISTRIB_HEADERS, object_name:AX_DISTRIB_HEADERS, status:VALID,
TABLE: AX.AX_STRUCTURES 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_STRUCTURES, object_name:AX_STRUCTURES, status:VALID,
VIEW: AX.AX_CONDITIONS# 12.2.2
owner:AX, object_type:VIEW, object_name:AX_CONDITIONS#, status:VALID,
SYNONYM: APPS.AX_CONDITIONS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:AX_CONDITIONS, status:VALID,
SYNONYM: APPS.AX_CONDITIONS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:AX_CONDITIONS, status:VALID,
VIEW: AX.AX_CONDITIONS# 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
Table: AX_STRUCTURES 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_STRUCTURES, object_name:AX_STRUCTURES, status:VALID, product: AX - Global Accounting Engine , description: Structures used by distribution plans to retrieve information , implementation_dba_data: AX.AX_STRUCTURES ,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
Table: AX_DISTRIB_HEADERS 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_DISTRIB_HEADERS, object_name:AX_DISTRIB_HEADERS, status:VALID, product: AX - Global Accounting Engine , description: Distribution headers of translation schemes , implementation_dba_data: AX.AX_DISTRIB_HEADERS ,
12.1.1 DBA Data 12.1.1
Table: AX_DISTRIB_HEADERS 12.2.2
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_DISTRIB_HEADERS, object_name:AX_DISTRIB_HEADERS, status:VALID, product: AX - Global Accounting Engine , description: Distribution headers of translation schemes , implementation_dba_data: AX.AX_DISTRIB_HEADERS ,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
Table: AX_STRUCTURES 12.1.1
owner:AX, object_type:TABLE, fnd_design_data:AX.AX_STRUCTURES, object_name:AX_STRUCTURES, status:VALID, product: AX - Global Accounting Engine , description: Structures used by distribution plans to retrieve information , implementation_dba_data: AX.AX_STRUCTURES ,
eTRM - AX Tables and Views 12.1.1
description: Absorption information ,
eTRM - AX Tables and Views 12.2.2
description: Absorption information ,
eTRM - AX Tables and Views 12.1.1
description: Absorption information ,
eTRM - AX Tables and Views 12.2.2
description: Absorption information ,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1