Search Results gl_plcy_mst

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:

• Primary Reference (PK): SY_ORGN_MST (via CO_CODE).
• Critical Financial References: GL_CURR_MST (BASE_CURRENCY_CODE), GL_LDGR_MST (PRIMARY_LEDGER_CODE).
• Cost Management References: CM_MTHD_MST (CREV_CURR_MTHD, CREV_PRIOR_MTHD), CM_CLDR_DTL (CREV_CURR_CALENDAR/PERIOD, CREV_PRIOR_CALENDAR/PERIOD), CM_ALYS_MST (MTL_ANALYSIS_CODE), CM_CMPT_MST (MTL_CMPNTCLS_ID).
• Child Tables (referencing GL_PLCY_MST.CO_CODE): A significant number of GL and GMF setup tables use the company code as a foreign key, including GL_ACCT_HRC, GL_ACCT_MST, GL_ACCU_MST, GL_PLCY_LGR, GL_PLCY_SEG, GL_PLCY_SYS, and GL_SUBR_LED. This demonstrates that the fiscal policy is a mandatory parent record for detailed account, segment, ledger, and subledger configurations.