Search Results cr_gled_cls




Overview
Explore in AI Chat

Overview

The CR_GLED_CLS table is a core reference table within the Oracle E-Business Suite (EBS) Process Manufacturing Process Planning (GMP) module. It serves as a master repository for Capacity General Ledger (G/L) Class Codes. These codes are critical for financial integration, enabling the classification and subsequent posting of capacity-related costs and transactions from the manufacturing floor to the General Ledger. The table's primary role is to provide descriptive definitions for these class codes, ensuring consistent financial categorization and reporting for capacity utilization, overhead absorption, and other cost accounting activities specific to process manufacturing environments. Its ownership under the GMP schema underscores its integral function in the Process Manufacturing product family.

Key Information Stored

The table's structure is designed to store code-description pairs for G/L classification. Based on the provided metadata, the primary key column is CRGL_CLASS, which stores the unique identifier for the G/L class code. A significant structural element is the foreign key relationship via the TEXT_CODE column to the CR_TEXT_HDR table. This relationship indicates that the descriptive text for the class code is likely stored in a flexible, multi-language descriptive flexfield (DFF) or a similar textual repository, allowing for translatable and extended descriptions beyond a simple column in the CR_GLED_CLS table itself. This design separates the code definition from its potentially lengthy and language-specific descriptions.

Common Use Cases and Queries

This table is predominantly used in setups, integrations, and reports. A common operational use case is during the configuration of cost accounting and capacity planning, where valid class codes from this table are assigned to resources or departments. For financial reporting, queries join this table to transaction tables to group and describe capacity-related GL postings. A fundamental query to retrieve all active class codes with their descriptions would involve joining to the text table:

  • SELECT gled.CRGL_CLASS, tl.DESCRIPTION FROM GMP.CR_GLED_CLS gled, GMP.CR_TEXT_HDR hdr, GMP.CR_TEXT_LINES tl WHERE gled.TEXT_CODE = hdr.TEXT_CODE AND hdr.TEXT_CODE = tl.TEXT_CODE AND tl.LANGUAGE = USERENV('LANG');

It is also critical for validating data in interfaces or custom programs that create capacity transactions destined for the General Ledger.

Related Objects

The CR_GLED_CLS table has defined relationships with several key EBS objects. Its primary foreign key dependency is on the CR_TEXT_HDR table, as documented, which in turn relates to CR_TEXT_LINES for the actual descriptive text in multiple languages. As a reference table holding valid codes, it is likely referenced by numerous transactional and setup tables within the GMP module that require a G/L class code, such as capacity transaction headers or resource definitions. While not listed in the brief metadata, tables like CR_GLED (Capacity G/L Entries) or CR_CAPACITY_TRANSACTIONS would be strong candidates for having foreign key relationships to CR_GLED_CLS to categorize their financial impact.