Search Results gl_evnt_mst




Overview
Explore in AI Chat

Overview

The GL_EVNT_MST table is a core master data table within the GMF (Process Manufacturing Financials) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the definitive repository for pre-defined Event codes. In the context of Oracle Process Manufacturing (OPM), an event is defined as any activity that has a financial impact, such as material consumption, production completion, or cost adjustments. This table provides the standardized codes that are referenced throughout the financial transaction lifecycle to categorize and account for these operational activities, ensuring consistent financial integration between OPM and the General Ledger.

Key Information Stored

The primary data stored in GL_EVNT_MST is the event type code, which acts as the unique identifier for a financial event. Based on the provided metadata and standard GMF table structures, the key column is EVENT_TYPE, which forms the table's primary key (GL_EVNT_MST_PK). While the exact column list is not fully detailed in the excerpt, related foreign key information indicates the presence of a TRANS_SOURCE_TYPE column. This column links to the GL_SRCE_MST table, which manages transaction source types, thereby classifying the event within a broader financial source framework. The table's design ensures each event is uniquely coded and associated with a valid transaction source.

Common Use Cases and Queries

This table is primarily referenced for validation, reporting, and setup purposes. A common use case is during the configuration of the GMF financial integration, where the valid list of events is reviewed or extended. For reporting, queries often join GL_EVNT_MST to transaction tables to produce financial analyses categorized by event type. A typical query pattern would retrieve all active event codes for a given source:

  • SELECT event_type, description FROM gl_evnt_mst WHERE trans_source_type = 'PRODUCTION';

Another critical use case is troubleshooting the posting of OPM transactions to GL, where verifying that a transaction's event code exists in GL_EVNT_MST is a fundamental step in diagnosing integration errors.

Related Objects

GL_EVNT_MST is a central reference table with several key dependencies, as indicated by its foreign keys. The table GL_SRCE_MST is a parent table, providing valid source types via the TRANS_SOURCE_TYPE column. Furthermore, GL_EVNT_MST is referenced as a parent table by other GMF entities. The GL_EVNT_PLC (Event Policy) table defines accounting rules for specific events, and the GL_SEVT_MST (Sub-Event Master) table holds more granular sub-event codes, both using EVENT_TYPE as a foreign key to GL_EVNT_MST. This structure creates a hierarchy: Source Type -> Event -> Sub-Event, which governs the financial accounting flow for manufacturing activities.