Search Results ic_gled_cls




Overview
Explore in AI Chat

Overview

The IC_GLED_CLS table is a core reference table within the Oracle Process Manufacturing (OPM) Inventory module (GMI) of Oracle E-Business Suite (EBS). It serves as the master repository for General Ledger (GL) class codes. These codes are critical for financial integration, acting as a key mapping point between inventory transactions in OPM and their corresponding accounting entries in the General Ledger. The table's primary function is to define and maintain a standardized set of classes that categorize inventory items and transactions, ensuring consistent and accurate financial posting across the manufacturing and inventory management processes.

Key Information Stored

The central data element stored in this table is the GL class code itself. Based on the provided metadata, the primary key column is ICGL_CLASS. This column holds the unique identifier for each General Ledger class. While the specific documentation excerpt does not list additional columns, typical reference tables like IC_GLED_CLS often include descriptive columns (e.g., a description field) and control columns for enabled status and creation/modification dates. The table's structure is designed to enforce data integrity, with the ICGL_CLASS column serving as the anchor for numerous foreign key relationships throughout the OPM schema.

Common Use Cases and Queries

The primary use case for IC_GLED_CLS is to support the financial accounting of inventory. When an inventory transaction (such as a material issue, receipt, or cost update) is processed, the system references the GL class associated with the item or warehouse to determine the correct GL account combination for posting. This is often managed through the GL_ACCT_MAP table. Common queries involve listing all active GL classes or identifying items assigned to a specific class for financial analysis. A fundamental reporting query would join IC_GLED_CLS to the item master to analyze the financial classification of inventory.

SELECT mst.item_no, mst.item_desc, cls.icgl_class
FROM ic_item_mst mst,
     ic_gled_cls cls
WHERE mst.gl_class = cls.icgl_class
ORDER BY cls.icgl_class, mst.item_no;

Related Objects

IC_GLED_CLS is a pivotal reference table with documented foreign key relationships to several important transactional and setup tables, as confirmed by the ETRM data:

  • GL_ACCT_MAP: This is a direct and crucial relationship. The GL_ACCT_MAP.ICGL_CLASS column references IC_GLED_CLS.ICGL_CLASS, forming the core link between an inventory GL class and its specific General Ledger account combinations.
  • IC_ITEM_MST (Item Master): The IC_ITEM_MST.GL_CLASS column references IC_GLED_CLS.ICGL_CLASS, assigning a default financial classification to each inventory item.
  • IC_WHSE_INV (Warehouse Inventory): The IC_WHSE_INV.GL_CLASS column references IC_GLED_CLS.ICGL_CLASS, allowing for financial class overrides at the specific warehouse level.
  • GMF_BURDEN_PERCENTAGES: The GMF_BURDEN_PERCENTAGES.ICGL_CLASS column references IC_GLED_CLS.ICGL_CLASS, linking GL classes to burden (overhead) cost calculations.
  • IC_TEXT_HDR: The IC_TEXT_HDR.TEXT_CODE references IC_GLED_CLS.TEXT_CODE (implied), associating descriptive text with a GL class.