Search Results ax_event_mappings_u1

Overview

AX.AX_EVENT_MAPPINGS is an E-Business Tax (EBS Tax / Oracle Tax) configuration table that stores the mapping between the primary key columns of the base event table of a translation scheme and the corresponding columns of AX_EVENTS. In the Oracle EBS 12.1.1 / 12.2.2 architecture of the E-Tax repository (schema owner AX), it acts as a resolution dictionary used by the tax engine to determine how a given event record (for example, an invoice line, a freight line, or a document-level event) is keyed and how those key values are compared against the events registered in the tax repository.

The object is documented as VALID with FND Design Data AX.AX_EVENT_MAPPINGS, resides in tablespace APPS_TS_TX_DATA (PCT Free 10), and contains ten columns. Heuristically, the Data Vault classification mined from the foreign key structure is satellite-leaning: the table primarily describes attributes of a business entity (the translation scheme) already identified elsewhere, rather than introducing a new independent hub. This is a modeling suggestion only; in the source system it is a standard relational lookup table whose rows belong to a parent translation scheme.

Key Information Stored

The table’s composite primary key, AX_EVENT_MAPPINGS_PK, and the unique index AX_EVENT_MAPPINGS_U1 share the same four columns: SET_OF_BOOKS_ID, APPLICATION_ID, TRANSLATION_SCHEME, and PRIMARY_KEY_COLUMN. These constitute the business key — there is no separate surrogate key column documented, so the composite key itself identifies each mapping row.

• SET_OF_BOOKS_ID – Ledger (set of books) identifier; scopes the mapping to a specific accounting context.
• APPLICATION_ID – Application identifier of the source event-owning application.
• TRANSLATION_SCHEME – Translation scheme name (VARCHAR2(30)); ties each row to a scheme defined in AX_TRANS_SCHEMES.
• PRIMARY_KEY_COLUMN – Name of a primary key column on the base event table (VARCHAR2(30)). One row exists per primary key column of that table.
• EVENT_FIELD – The mapping target: the column in AX_EVENTS to which the base-table key column must be compared (VARCHAR2(30)).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN – Standard Who audit columns recording who created and last modified each mapping.

Common Use Cases and Queries

The primary practical use is troubleshooting or auditing how tax events are joined to their base transactions. A configuration analyst might verify which column of AX_EVENTS is compared to a given primary key column for a translation scheme, or confirm that every key column of a base event table has a mapping row. A typical query lists all mappings for a ledger, application, and scheme:

• SELECT translation_scheme, primary_key_column, event_field FROM ax.ax_event_mappings WHERE set_of_books_id = :p_sob AND application_id = :p_app ORDER BY primary_key_column;
• Detection of unmapped key columns: compare the row count in AX_EVENT_MAPPINGS for a scheme against the number of primary key columns on the base event table.
• Reporting of mapping coverage across ledgers using a GROUP BY set_of_books_id, application_id with COUNT(*).
• Change auditing by filtering on last_update_date > :cutoff to identify recently modified mappings.

Related Objects

The documented foreign key relationship links AX_EVENT_MAPPINGS.SET_OF_BOOKS_ID (and by design APPLICATION_ID and TRANSLATION_SCHEME) to AX_TRANS_SCHEMES, which is the authoritative registry of translation schemes. Consequently, the most significant related objects are:

• AX.AX_TRANS_SCHEMES – Parent table; join on SET_OF_BOOKS_ID, APPLICATION_ID, and TRANSLATION_SCHEME.
• AX.AX_EVENTS – Target table referenced by EVENT_FIELD; the mapping resolves which AX_EVENTS column is used for key comparison.
• The base event tables of each application (for example, transaction line tables owned by Receivables, Payables, or Purchasing) whose primary key columns are described by PRIMARY_KEY_COLUMN.
• Tax configuration and event-setup UI pages that populate this table when a translation scheme is defined.