Search Results ax_event_types_pk

Overview

AX_EVENT_TYPES is a Global Accounting Engine (AX) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. The AX module — also known as the Global Accounting Engine — provides a centralized accounting engine that converts subledger transactions into accounting entries posted to General Ledger. Within that architecture, AX_EVENT_TYPES defines the set of event types recognized by the accounting engine for a given ledger and application, and it controls how each event type is translated and posted.

Each row associates an event type with a specific set of books and a source application, and it references a translation scheme that determines the debit and credit derivation logic. The table also records whether a given event type is enabled, whether it posts directly, whether it participates in a program, and whether a user exit is invoked. In this respect the table functions as a driver of the accounting generation process rather than as a transactional fact table.

From a Data Vault modeling perspective, the heuristic classification of AX_EVENT_TYPES is a link. Its primary key is composite and is composed entirely of foreign key columns, which is characteristic of a link table connecting related hubs. This classification should be treated as a modeling suggestion rather than a documented fact.

Key Information Stored

The primary key, AX_EVENT_TYPES_PK, consists of four columns: SET_OF_BOOKS_ID, APPLICATION_ID, POSTING_SET_OF_BOOKS_ID, and EVENT_TYPE. A unique index, AX_EVENT_TYPES_U1, covers the identical four-column combination, so this same set of columns serves as both the surrogate primary key and the business-key candidate. There is no separate single-column surrogate identifier documented.

The most significant columns are:

• SET_OF_BOOKS_ID — identifies the ledger for which the event type definition applies.
• POSTING_SET_OF_BOOKS_ID — identifies the set of books used for posting, which may differ from the definition ledger.
• APPLICATION_ID — the source application that owns the event type.
• EVENT_TYPE — the event type identifier, such as an invoice, payment, or journal-related event.
• TRANSLATION_SCHEME — the scheme used to translate the event into accounting entries.
• CATEGORY_CODE — classifies the event for reporting and processing purposes.
• ENABLED_FLAG — indicates whether the event type is currently active.
• DIRECT_FLAG — controls whether the event posts directly.
• INCLUDE_IN_PROGRAM_FLAG — determines whether the event participates in the associated translation or posting program.
• USER_EXIT — names the user exit invoked for custom processing.
• DESCRIPTION — the descriptive name of the event type.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns maintained by EBS.

Common Use Cases and Queries

A frequent requirement is to list all enabled event types for a given ledger and application, which is useful during implementation review or troubleshooting of missing accounting entries.

• SELECT event_type, description, enabled_flag, direct_flag FROM ax.ax_event_types WHERE set_of_books_id = :ledger_id AND application_id = :app_id AND enabled_flag = 'Y';
• Join to AX_TRANS_SCHEMES to display the translation scheme name associated with each event type: SELECT a.event_type, s.name FROM ax.ax_event_types a, ax.ax_trans_schemes s WHERE a.set_of_books_id = s.set_of_books_id AND a.application_id = s.application_id AND a.translation_scheme = s.translation_scheme;
• Identify event types configured with a user exit for custom logic: SELECT event_type, user_exit FROM ax.ax_event_types WHERE user_exit IS NOT NULL;
• Report event types excluded from program processing: SELECT event_type FROM ax.ax_event_types WHERE include_in_program_flag = 'N';

These queries support functional configuration validation, migration checks between environments, and audit of the accounting engine setup.

Related Objects

The foreign keys documented in the metadata link AX_EVENT_TYPES to two parent tables.

• AX_TRANS_SCHEMES — referenced through SET_OF_BOOKS_ID, APPLICATION_ID, and TRANSLATION_SCHEME, defining the translation logic for the event type.
• AX_TRANS_PROGRAMS — referenced through APPLICATION_ID, SET_OF_BOOKS_ID, and POSTING_SET_OF_BOOKS_ID, defining the posting program associated with the event type.
• AX_EVENT_TYPES_PK and AX_EVENT_TYPES_U1 — the primary key constraint and the associated unique index, both enforcing the four-column business key.

Together these objects form the configuration backbone of the Global Accounting Engine, with AX_EVENT_TYPES acting as the central linkage between ledgers, applications, translation schemes, and posting programs.