Search Results gl_plcy_lgr




Overview
Explore in AI Chat

Overview

The GL_PLCY_LGR 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 a junction table that defines the relationship between a company policy (CO_CODE) and the specific ledgers (LEDGER_CODE) assigned to it. This mapping is fundamental for establishing the financial and accounting structure within a manufacturing enterprise, ensuring that transactional data is posted to the correct ledger according to the governing company's policy. Its existence within the GMF schema underscores its critical role in integrating manufacturing operations with the General Ledger (GL).

Key Information Stored

The table's structure is intentionally simple, designed to enforce a many-to-many relationship between two key entities. The primary information it stores consists of two columns that form its composite primary key, GL_PLCY_LGR_PK. The CO_CODE column references a specific company policy defined in the GL_PLCY_MST table. The LEDGER_CODE column references a specific ledger defined in the GL_LDGR_MST table. Together, these columns create an authoritative list of which ledgers are valid and available for financial posting under a given company's accounting policy. The table does not typically store transactional amounts or descriptive attributes; its sole purpose is to maintain this critical assignment.

Common Use Cases and Queries

The primary use case for GL_PLCY_LGR is to validate and control ledger assignments during financial transaction processing in GMF. It is frequently queried in the background of application logic to ensure data integrity. Common reporting and validation queries include listing all ledgers for a specific company policy or identifying which policy governs a particular ledger. For example, a typical SQL pattern to retrieve this mapping would be:

  • SELECT plcy.co_code, plcy.co_name, lgr.ledger_code, ldgr.ledger_name
  • FROM gmf.gl_plcy_lgr lgr,
  • gmf.gl_plcy_mst plcy,
  • gmf.gl_ldgr_mst ldgr
  • WHERE lgr.co_code = plcy.co_code
  • AND lgr.ledger_code = ldgr.ledger_code
  • AND plcy.co_code = :p_co_code;

This data is essential for setups, audits, and troubleshooting integration points between GMF manufacturing transactions and the General Ledger.

Related Objects

As indicated by its foreign keys, GL_PLCY_LGR has direct dependencies on two master tables. The GL_PLCY_MST table (via CO_CODE) contains the definition of company policies, which are high-level sets of accounting rules. The GL_LDGR_MST table (via LEDGER_CODE) contains the definition of ledgers, which are the primary accounting books. This table acts as the critical link between these two master entities. Consequently, any setup, data load, or integration process that involves assigning a ledger to a company policy will interact with this table. It is a foundational component for the financial configuration of the GMF module.