Search Results gl_plcy_seg




Overview
Explore in AI Chat

Overview

The GL_PLCY_SEG 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 serves as the foundational repository for the Chart of Accounts (COA) structure, specifically designed to support account key segregation. This table defines the individual segments that constitute the accounting flexfield, enabling the detailed classification and hierarchical organization of financial accounts. Its primary role is to store the segment-level metadata that, when combined with the master policy definitions in related tables, forms the complete accounting key structure used for financial transactions, reporting, and compliance within a process manufacturing environment.

Key Information Stored

The table stores the structural definition of each segment within the Chart of Accounts. While the full column list is not detailed in the provided metadata, the documented primary key and foreign key constraints reveal its critical components. The primary key is a composite of CO_CODE and SEGMENT_NO. The CO_CODE column identifies the specific Chart of Accounts or accounting policy, linking it to the GL_PLCY_MST table. The SEGMENT_NO column uniquely identifies the sequence or position of a segment within that specific COA structure. Other typical columns in such a structure would define segment names, lengths, validation rules, and display characteristics, enabling the system to construct valid account combinations and enforce accounting integrity.

Common Use Cases and Queries

This table is central to any setup, maintenance, or reporting activity involving the accounting flexfield in GMF. A common use case is the validation and generation of legal account combinations during journal entry creation. System administrators query this table to review or modify the COA segment structure during implementation or upgrades. For reporting, it is often joined to transaction tables to decode segment IDs into meaningful descriptions. A fundamental query pattern retrieves the segment structure for a given Chart of Accounts:

  • SELECT * FROM GMF.GL_PLCY_SEG WHERE CO_CODE = '&COA_CODE' ORDER BY SEGMENT_NO;

Another critical use is in data validation scripts, ensuring that transactional data aligns with the defined segment ranges and rules stored in this table.

Related Objects

The GL_PLCY_SEG table has a direct and documented foreign key relationship with the GL_PLCY_MST table, which is the master policy definition table. The relationship is defined as:

  • Foreign Key from GL_PLCY_SEG to GL_PLCY_MST: The GL_PLCY_SEG.CO_CODE column references the corresponding code in GL_PLCY_MST. This ensures that every segment definition is associated with a valid, higher-level accounting policy.

Consequently, GL_PLCY_SEG is a child table of GL_PLCY_MST. This table is also a likely parent to numerous other transactional and setup tables within GMF that store actual segment values (e.g., account combinations), forming the backbone of the financial data model for process manufacturing.