Search Results process_item_unit_cost

Overview

GMF_CMCOMMON is the shared cost-management utility package within the Oracle Process Manufacturing (OPM) costing subsystem in Oracle E-Business Suite. It centralizes the low-level logic used to resolve item costs, resource costs, component costs, and batch-level cost status for process manufacturing organizations. Because process costing differs substantially from discrete costing — involving lot-based costs, fiscal policies, component classes, analysis codes, and resource detail lines — GMF_CMCOMMON provides a single, consistent API surface that other OPM costing programs call rather than duplicating cost retrieval logic.

The package header identifies its core routine, cmcommon_get_cost, which retrieves item cost, cost type, and fmeff_id from GL_ITEM_CST, along with component cost amounts from GL_ITEM_DTL. The routine supports multiple retrieve modes (1 through 5) that govern whether the caller receives accounting cost alone, all component cost amounts, component costs filtered by class and analysis code, or arrays and totals of PPV/Material cost-component values. Global cached organization and cost-method variables were introduced to avoid redundant lookups when repeated calls target the same organization and cost method.

Key Procedures and Functions

• CMCOMMON_GET_COST — The foundational routine. Returns the cost of an item for the cost warehouse when one is associated with the given warehouse; otherwise returns the cost for the given warehouse. It also returns cost type and fmeff_id, and (depending on retrieve_ind) component cost amounts, component class IDs, and analysis codes, or a totaled PPV/Material value.
• GET_MULTIPLE_CMPTS_COST — Retrieves costs for multiple components in a single call, supporting batch or multi-line cost roll-ups.
• GET_CMPT_COST — Resolves the cost of an individual component, typically resolved against the component master and component detail tables.
• GET_RSRC_COST — Returns resource cost information, drawing on resource detail definitions.
• UNIT_COST — Computes or returns the unit cost for an item or process item.
• GET_PROCESS_ITEM_COST and PROCESS_ITEM_UNIT_COST — Return the cost and unit cost of a process item respectively, used in process-batch costing flows.
• GET_PROCESS_ITEM_PRICE and GET_PROCESS_ITEM_UNIT_PRICE — Return the price and unit price of a process item, used where a valuation based on price rather than cost is required.
• GET_SORT_SEQUENCE — Supplies the ordering sequence used when presenting or processing cost components.
• IS_BATCH_COST_FROZEN — Indicates whether a batch's cost has been frozen, preventing recalculation and ensuring period integrity.

Tables Accessed

The package reads and references a defined set of OPM costing and master tables through APPS synonyms:

• GL_ITEM_CST, GL_ITEM_DTL — Item cost headers and detail component costs; the primary source for cost and fmeff_id.
• CM_ALYS_MST, CM_CMPT_MST, CM_CMPT_DTL — Analysis-code, component-class, and component-detail masters that qualify which component costs apply.
• CM_WHSE_ASC — Warehouse association, used to determine the cost warehouse for an item/warehouse combination.
• CM_ACST_LED, CM_MTHD_MST, CM_RSRC_DTL — Actual cost ledger, cost-method master, and resource detail; resource and method context for costing.
• SY_ORGN_MST — Organization master, supplying organization context and validation.
• GMF_FISCAL_POLICIES — Fiscal policy definitions that govern cost period behavior.
• GMF_LOT_COSTS, GMF_LOT_COST_DETAILS — Lot-level cost records, central to process-manufacturing valuation.
• GME_BATCH_HEADER, GME_MATERIAL_DETAILS — Batch and material detail lines, used for batch-level cost determination and freeze checks.

Usage Notes

GMF_CMCOMMON is a programmatic utility, not an end-user screen. It is invoked indirectly by other OPM costing packages — the documented metadata notes it is referenced by 22 other packages — and by concurrent programs performing cost roll-up, cost update, and lot-cost calculation. It is also commonly called from custom PL/SQL extensions that need OPM-consistent item, component, resource, or batch cost values rather than reimplementing the retrieval logic. Callers should note that cmcommon_get_cost caches organization and cost method globally, so repeated calls within a session for the same organization and cost method reuse cached values; where organization or method changes between calls, this caching must be accounted for. Because IS_BATCH_COST_FROZEN guards against recalculation of frozen costs, custom code should test this condition before attempting to overwrite batch cost values.