Search Results gl_item_cst




Overview
Explore in AI Chat

Overview

The GL_ITEM_CST table is a core data object within the Oracle E-Business Suite Process Manufacturing Financials (GMF) module. It serves as the central repository for storing and maintaining item cost information for transactions. Its primary role is to hold both the accounting cost (the cost used for financial ledger postings) and the current cost for items, facilitating accurate inventory valuation and cost accounting within a process manufacturing environment. The table is integral to the GMF cost management system, enabling the tracking of cost changes over time by period and by cost method. As indicated by its foreign key relationships, it is a master table that is heavily referenced, particularly by the GL_ITEM_DTL table, which stores the detailed component breakdown of these costs.

Key Information Stored

The table's structure is designed to uniquely identify a cost record for a specific item within a defined organizational and temporal context. Based on the provided metadata, the composite primary key (GL_ITEM_CST_U1) consists of the following critical columns: ORGN_CODE (organization), WHSE_CODE (warehouse), ITEM_ID, COST_MTHD_CODE (cost method), and END_DATE. This design allows for maintaining a history of costs. The surrogate primary key, ITEMCOST_ID, is used for efficient relational joins. Other significant columns include CALENDAR_CODE and PERIOD_CODE to tie the cost to a specific accounting period, and FMEFF_ID to link to a formula effectivity, which is crucial in process manufacturing where costs can vary by production recipe. The table stores the actual cost amounts in columns not explicitly listed in the brief metadata but typically named such as ACCT_COST, CURR_COST, or similar.

Common Use Cases and Queries

This table is essential for financial reporting, inventory valuation reports, and cost analysis. A common operational use case is retrieving the current accounting cost for an item to value an inventory transaction or to serve as a basis for cost updates. Analysts frequently query this table to analyze cost history or to reconcile inventory valuations to the general ledger. Sample SQL patterns include retrieving the active cost for an item (where END_DATE is null or in the future) or joining to item and organization master tables for comprehensive reporting.

  • Sample Query for Current Cost: SELECT * FROM GMF.GL_ITEM_CST c WHERE c.ORGN_CODE = :p_org AND c.ITEM_ID = :p_item AND c.COST_MTHD_CODE = :p_method AND c.END_DATE IS NULL;
  • Reporting Use Case: Generating a period-end inventory valuation report by joining GL_ITEM_CST with IC_ITEM_MST_B for item descriptions and SY_ORGN_MST for organization details, then calculating total value by summarizing quantity on hand from inventory tables multiplied by the accounting cost from GL_ITEM_CST.

Related Objects

The GL_ITEM_CST table sits at the center of a network of related master and transactional tables, as documented by its foreign key constraints. Key relationships include:

  • Primary Detail Table: GL_ITEM_DTL joins to GL_ITEM_CST via GL_ITEM_DTL.ITEMCOST_ID to provide component-level cost details.
  • Master Data References: It references numerous master tables to ensure data integrity:
    • CM_CLDR_DTL via CALENDAR_CODE and PERIOD_CODE (accounting calendar).
    • CM_MTHD_MST via COST_MTHD_CODE (cost method definition).
    • FM_FORM_EFF via FMEFF_ID (formula effectivity).
    • IC_ITEM_MST_B and IC_ITEM_MST via ITEM_ID (item master).
    • IC_WHSE_MST via WHSE_CODE (warehouse master).
    • SY_ORGN_MST_B and SY_ORGN_MST via ORGN_CODE (organization master).

These relationships underscore that GL_ITEM_CST is a pivotal table integrating manufacturing, inventory, and financial data within Oracle EBS Process Manufacturing.