Search Results gl_plcy_mst




Overview
Explore in AI Chat

Overview

The GL_PLCY_MST table is a core master data table within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It stores the definition of a company's fiscal policy, which fundamentally governs the General Ledger (GL) attributes and accounting rules for that legal entity. Each record represents the financial configuration for a specific company (CO_CODE), establishing the foundational accounting framework that dictates how transactions are processed, valued, and reported in the GL. Its central role is to link a company to its critical financial settings, such as its base currency, primary ledger, and cost revision methods, thereby serving as a pivotal reference point for numerous other financial and costing tables within the GMF and GL architecture.

Key Information Stored

The table's primary key is the company code (CO_CODE), uniquely identifying each fiscal policy. Based on the documented foreign key relationships, other significant columns include: BASE_CURRENCY_CODE, which references the company's functional currency; PRIMARY_LEDGER_CODE, which identifies the main accounting ledger; and CREV_CURR_MTHD, CREV_PRIOR_MTHD, CREV_CURR_CALENDAR, and CREV_PRIOR_PERIOD, which define the current and prior cost revision methodologies and their associated accounting calendars. Additional columns link to components like MTL_ANALYSIS_CODE for material analysis, MTL_CMPNTCLS_ID for component class, and TEXT_CODE for descriptive text. Collectively, these fields encapsulate the essential GL policy for a company.

Common Use Cases and Queries

This table is primarily queried for financial configuration analysis, integration support, and data validation. Common scenarios include identifying the base currency and primary ledger for a given company during interface development, validating cost accounting setups, and generating reference reports for audit purposes. A typical query would join GL_PLCY_MST to SY_ORGN_MST to get the company name and to GL_CURR_MST for the currency details.

  • Sample Query: To retrieve a company's core financial setup:
    SELECT gp.co_code, so.organization_name, gp.base_currency_code, gc.name currency_name, gp.primary_ledger_code
    FROM gmf.gl_plcy_mst gp,
         apps.sy_orgn_mst so,
         apps.gl_curr_mst gc
    WHERE gp.co_code = so.organization_code
    AND gp.base_currency_code = gc.currency_code
    AND gp.co_code = :p_company_code;

Related Objects

As evidenced by its extensive foreign key network, GL_PLCY_MST is a central hub in the GMF schema. Key relationships include: