Search Results ax_arithmetic_expr_u1

Overview

AX.AX_ARITHMETIC_EXPR is a transactional configuration table in the Oracle E-Business Suite 12.1.1 / 12.2.2 environment, owned by the AX schema. It stores the elementary arithmetic expressions that compose the amount structures used by the Oracle ETRM (Energy and Commodity Trading and Risk Management) amount-calculation engine. Each row represents a single elementary expression and captures the arithmetic operator (+, −, * or /), the type of the right-hand operand (COLUMN, CONSTANT or EVENT_DATA), and the operand value or source reference. The table is therefore the lowest-level building block of the formula definitions that drive calculated amounts within a distribution plan.

Physically the table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, while its unique index is stored separately in APPS_TS_TX_IDX. The documented schema exposes 16 columns. Applying Data Vault modelling heuristics to the foreign-key structure, this object is classified as satellite-leaning: it holds descriptive, time-stamped attributes (operator, operand type, source references, Who columns) attached to a composite business key that is itself defined by its parent structure. It is not an independent hub.

Key Information Stored

The composite primary key, AX_ARITHMETIC_EXPR_PK, consists of seven columns: SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, PLAN_NAME, STRUCTURE_NUMBER, STRUCTURE_TYPE and EXPRESSION_NUMBER. Together these form the mandatory context that uniquely identifies each expression. The unique index AX_ARITHMETIC_EXPR_U1 enforces exactly the same seven-column combination, confirming it as the business-key candidate and the governing uniqueness constraint for the table.

• SET_OF_BOOKS_ID – identifies the set of books under which the expression is defined.
• APPLICATION_ID – the owning application identifier.
• TRANSLATION_SCHEME – the translation scheme name (VARCHAR2 30) scoping the expression.
• PLAN_NAME – the distribution plan to which the structure belongs (VARCHAR2 30).
• STRUCTURE_TYPE – the type of structure (VARCHAR2 30).
• STRUCTURE_NUMBER – the number of the structure within its type per distribution plan.
• EXPRESSION_NUMBER – the ordinal number of the expression within its structure.
• OPERATOR – the arithmetic operator applied by this elementary expression.
• OPERAND_TYPE – classifies the right operand as COLUMN, CONSTANT or EVENT_DATA (VARCHAR2 30).
• SOURCE_TABLE – the source table name supplying the operand (VARCHAR2 30).
• SOURCE_COLUMN_VALUE – the source column name or constant value (VARCHAR2 30).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – the standard Who audit columns maintained by EBS.

Common Use Cases and Queries

Typical usage is diagnostic and reporting-oriented: reconstructing the formula behind a calculated amount, auditing changes to plan definitions, or tracing which source column feeds a given expression. A retrieval by the business key is the most frequent access pattern and is fully supported by AX_ARITHMETIC_EXPR_U1.

• Fetch all expressions for a structure, ordered by EXPRESSION_NUMBER, to rebuild the arithmetic sequence.
• Filter by OPERAND_TYPE to isolate expressions that reference event data versus constants or columns.
• Resolve SOURCE_TABLE and SOURCE_COLUMN_VALUE to identify the originating data for each operand.
• Audit recent changes using LAST_UPDATE_DATE and LAST_UPDATED_BY within a set of books.

A representative query pattern joins the expression rows to their parent structure on the shared composite key columns, selecting OPERATOR, OPERAND_TYPE, SOURCE_TABLE and SOURCE_COLUMN_VALUE ordered by EXPRESSION_NUMBER. Because the unique index covers the leading key columns, such predicates are index-driven and efficient.

Related Objects

The dominant relationship is the foreign-key dependency on AX_STRUCTURES, which owns the same composite key columns (SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, PLAN_NAME, STRUCTURE_TYPE, STRUCTURE_NUMBER). Any query or extract must join AX_ARITHMETIC_EXPR to AX_STRUCTURES on those columns to obtain the structure definition that the expressions belong to. Within the AX module, the related reference and planning objects that share this key context include the structures table itself, the distribution plan definitions that reference PLAN_NAME and TRANSLATION_SCHEME, the event-data definitions that back OPERAND_TYPE = 'EVENT_DATA' rows, and the amount-calculation routines that consume the assembled expression list. Reporting against this object should always be scoped by SET_OF_BOOKS_ID and PLAN_NAME to remain performant and business-meaningful.