Search Results gl_subr_led




Overview
Explore in AI Chat

Overview

The GL_SUBR_LED table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the subsidiary ledger, serving as the critical liaison between Oracle Process Manufacturing (OPM) subsystems and the General Ledger (GL). Its primary role is to store detailed transactional accounting entries, or "bookings," generated from OPM subsystem documents such as production, inventory, and cost transactions. These entries are populated and updated by the OPM Subsidiary Ledger Update process, which prepares the data for eventual posting and reconciliation with the central GL. This table is essential for maintaining a granular, auditable trail of financial impacts originating from manufacturing operations before their summarization in the general ledger.

Key Information Stored

The table captures the complete accounting attributes for each subsidiary ledger entry. Key columns include SUBLEDGER_ID, the primary key uniquely identifying each booking. It stores fundamental accounting dimensions such as ACCT_ID (the detailed account), LEDGER_CODE, and CO_CODE (company/legal entity). Transaction-specific data is held in columns like REFERENCE_NO (linking to the source OPM document), TRANS_SOURCE_TYPE, and SUB_EVENT_TYPE. Monetary amounts are recorded with CURRENCY_BASE and CURRENCY_TRANS columns, while QUANTITY_UM and related fields capture the unit of measure and quantity for material-based transactions. The table also includes period and date information, status flags, and foreign key references to numerous master tables, ensuring referential integrity across the financial architecture.

Common Use Cases and Queries

The primary use case is tracing the detailed accounting impact of OPM transactions. Analysts query this table to investigate discrepancies between OPM subledger totals and GL balances, audit specific manufacturing events, or generate detailed operational financial reports. Common SQL patterns involve joining to master tables to translate codes into meaningful descriptions. For example, a query to analyze production variance postings might join GL_SUBR_LED to GL_ACCT_MST and GL_SRCE_MST, filtering on relevant SUB_EVENT_TYPE and accounting period. The table is also central to custom reconciliation reports that aggregate amounts by ledger, account, and source document before comparing them to GL journal line summaries.

Related Objects

GL_SUBR_LED maintains extensive foreign key relationships with foundational GMF and GL master tables, as documented in the ETRM. These relationships are critical for data validation and reporting:

These relationships define the table's position as the central junction point between transactional detail and the enterprise's chart of accounts, ledger structure, and currency definitions.