Search Results gl_sevt_ttl




Overview
Explore in AI Chat

Overview

The GL_SEVT_TTL table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a mapping table that defines the specific General Ledger (GL) account titles impacted by a given subsystem subevent. In the context of manufacturing and cost accounting, a subevent represents a discrete transactional activity (e.g., a material issue, a resource charge) that triggers financial postings. This table links these operational subevents to the appropriate accounting titles, thereby establishing the rules for how financial entries are generated and mapped to the GL during transaction processing. Its role is critical for ensuring accurate and automated accounting flow from manufacturing execution systems to the general ledger.

Key Information Stored

The table's structure is designed to map subevents to account titles through a combination of key identifiers. The primary key is a composite of two columns: SUB_EVENT_TYPE and SEQUENCE_NO. The SUB_EVENT_TYPE identifies the specific manufacturing or cost accounting subevent, while the SEQUENCE_NO dictates the order in which multiple account titles may be applied for a single subevent. A crucial foreign key column is ACCT_TTL_TYPE, which references the GL_ACCT_TTL table to specify the exact account title (e.g., Material Usage, Resource Variance) to be debited or credited. This column is the direct link to the chart of accounts structure. Collectively, these columns store the rule set that dictates the accounting consequences of operational transactions.

Common Use Cases and Queries

The primary use case for GL_SEVT_TTL is during the financial integration process, where manufacturing transactions are costed and journal entries are created. A typical query would retrieve all account title mappings for a specific subevent to validate or audit the accounting setup. For example:

  • To list the accounting impact of a 'WIP Completion' subevent: SELECT sequence_no, acct_ttl_type FROM gl_sevt_ttl WHERE sub_event_type = 'WIP_COMPLETION' ORDER BY sequence_no;
  • To verify the full account title description for a mapping: SELECT sevt.sub_event_type, sevt.sequence_no, sevt.acct_ttl_type, ttl.description FROM gl_sevt_ttl sevt, gl_acct_ttl ttl WHERE sevt.acct_ttl_type = ttl.acct_ttl_type AND sevt.sub_event_type = '&sub_event';

This data is essential for troubleshooting journal generation errors, implementing new accounting rules, and generating reports on the subevent-to-account mapping configuration.

Related Objects

GL_SEVT_TTL is centrally connected to two other key GMF tables via foreign key relationships. It directly references GL_SEVT_MST (GL Subevent Master) through its SUB_EVENT_TYPE column. GL_SEVT_MST contains the master definition and description of the subevents themselves. Furthermore, it references GL_ACCT_TTL (GL Account Titles) through its ACCT_TTL_TYPE column. GL_ACCT_TTL defines the valid accounting titles used within the system. Therefore, GL_SEVT_TTL sits between these two master tables, forming the essential bridge that translates an operational event (from GL_SEVT_MST) into a formal accounting element (from GL_ACCT_TTL). Any process or report concerning subevent accounting will inherently involve these related objects.