Search Results gl_ldgr_mst




Overview
Explore in AI Chat

Overview

The GL_LDGR_MST 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 serves as the master repository for General Ledger (GL) ledger definitions. In the context of GMF, which extends standard financials to handle the unique costing and accounting requirements of process manufacturing, this table stores the fundamental ledger entities against which financial transactions are recorded and consolidated. Its primary role is to establish and maintain the ledger structure, which is a critical prerequisite for financial processing and reporting within the integrated manufacturing and financial environment.

Key Information Stored

The table's structure centers on the LEDGER_CODE column, which is the unique identifier for a ledger and serves as the table's primary key (GL_LDGR_MST_PK). While the provided metadata does not list all columns, the existence of foreign key relationships indicates it stores essential ledger attributes that other modules reference. The key data point is the ledger code itself, which is used throughout the GMF and potentially other EBS modules to associate transactions, policies, and mappings with a specific financial ledger. The table's description as "GL ledgers" confirms it holds the master record for each ledger entity used in the system.

Common Use Cases and Queries

This table is primarily referenced for setup validation, data integrity checks, and as a source for master data in reports. Common operational scenarios include validating ledger codes during transaction entry, generating lists of active ledgers for configuration reviews, and supporting reconciliation processes. A fundamental query to retrieve all defined ledgers would be: SELECT LEDGER_CODE FROM GMF.GL_LDGR_MST ORDER BY LEDGER_CODE;. In troubleshooting or auditing, one might join this table to transaction tables like PO_DIST_DTL to verify that distribution lines reference valid ledgers: SELECT DISTINCT d.LEDGER_CODE, m.LEDGER_CODE FROM PO_DIST_DTL d, GL_LDGR_MST m WHERE d.LEDGER_CODE = m.LEDGER_CODE(+);.

Related Objects

As indicated by the foreign key relationships, GL_LDGR_MST is a central reference point for several other GMF tables. Key dependent objects include:

  • GL_LEDG_MAP: Maps ledgers to other entities.
  • GL_PLCY_LGR and GL_PLCY_MST: Associate financial policies with specific ledgers, with GL_PLCY_MST using it to identify a primary ledger.
  • GL_SUBR_LED and GL_SUBR_TST: Likely relate to sub-ledger accounting and testing.
  • PO_DIST_DTL: Demonstrates integration with Purchasing, where purchase order distributions are tied to a GMF ledger.
These relationships enforce data integrity, ensuring that transactional records reference only valid, pre-defined ledgers from the GL_LDGR_MST master table.