Search Results gl_plcy_sys




Overview
Explore in AI Chat

Overview

The GL_PLCY_SYS table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a junction or detail table that defines the specific sub-systems or transaction sources associated with a broader fiscal policy. Its primary role is to establish and enforce the linkage between a company's fiscal policy and the various operational subsystems (e.g., Inventory, Purchasing, Order Management) from which financial transactions originate. This linkage is critical for ensuring that transactions from different sources are processed according to the correct accounting rules and calendar periods defined by the overarching fiscal policy.

Key Information Stored

The table's structure is designed to map a fiscal policy to its applicable transaction sources. Based on the provided metadata, the key columns include the composite primary key and foreign key columns. The CO_CODE column stores the unique identifier for the company or legal entity. The TRANS_SOURCE_CODE column holds the code representing a specific transaction source or sub-system within the EBS, such as 'INV' for Inventory or 'PO' for Purchasing. Together, these columns form the primary key (GL_PLCY_SYS_PK), ensuring a unique combination of company and transaction source for a given fiscal policy context. The table's description, "Fiscal policy sub-systems," confirms its purpose of storing this mapping relationship.

Common Use Cases and Queries

This table is central to configuration and validation processes within GMF. A common use case is during the setup of financial integration, where an implementer must define which transaction sources are governed by a specific fiscal policy. Reporting and audit queries often join this table to the policy master to verify or list all configured subsystems. A typical SQL pattern retrieves all transaction sources enabled for a company:

  • SELECT trans_source_code FROM gl_plcy_sys WHERE co_code = :company_code;

Another critical use case is within transaction processing logic, where the system references GL_PLCY_SYS to determine the correct fiscal policy to apply based on the transaction's source company and originating module before creating accounting entries.

Related Objects

The primary documented relationship for the GL_PLCY_SYS table is its foreign key dependency on the fiscal policy master table. As per the ETRM metadata:

  • Foreign Key to GL_PLCY_MST: The CO_CODE column in GL_PLCY_SYS references the CO_CODE column in the GL_PLCY_MST (Fiscal Policy Master) table. This relationship enforces that a sub-system mapping can only be created for a company that has an existing fiscal policy master record. GL_PLCY_MST defines the core policy attributes (like calendar, ledger), while GL_PLCY_SYS specifies the operational scope of that policy.

This relationship is fundamental, indicating that GL_PLCY_SYS is a child table of GL_PLCY_MST, and its records are subordinate to and controlled by the master fiscal policy definition.