Search Results get_rsrc_cost

Overview

GMF_CMCOMMON is an Oracle Application Object Library package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is a foundational component of the Process Manufacturing (OPM) costing subsystem, providing the shared programmatic logic used to determine, calculate, and retrieve costs for process manufacturing items, components, resources, and batches. Rather than representing a discrete business transaction, the package supplies reusable costing routines consumed broadly across the OPM financial and manufacturing modules. Its API classification is OTHER, reflecting its role as an internal utility rather than a public interface.

The package operates primarily within the Process Costing and CM (Cost Management) application, where it supports the valuation of production batches, material issues, and resource consumption. It abstracts the complexity of cost rollup logic, fiscal policy lookups, and cost element retrieval so that calling modules can obtain consistent, correctly priced values without duplicating calculation code. Because it is VALID and is referenced by 22 other packages, it functions as a dependency hub within the OPM costing stack.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, focused on cost derivation and status evaluation:

• CMCOMMON_GET_COST — the central routine for retrieving common costing information across entities.
• GET_MULTIPLE_CMPTS_COST — returns costs for multiple components in a single invocation.
• GET_SORT_SEQUENCE — supplies ordering logic, typically for cost element or component sequencing.
• UNIT_COST — derives the unit cost for a supplied item or cost entity.
• GET_PROCESS_ITEM_COST — returns the cost of a process manufacturing item.
• IS_BATCH_COST_FROZEN — evaluates whether a batch's cost has been frozen, guarding against recalculation.
• GET_PROCESS_ITEM_UNIT_PRICE and GET_PROCESS_ITEM_PRICE — retrieve pricing (unit and aggregate) for process items.
• PROCESS_ITEM_UNIT_COST — computes unit cost specifically for a process item.
• GET_CMPT_COST — returns component-level cost.
• GET_RSRC_COST — returns resource-level cost.

These routines collectively support the retrieval of cost, price, component, resource, and freeze-status data required during costing runs and transactional valuation. Parameter lists are not enumerated here, consistent with the documented metadata.

Tables Accessed

GMF_CMCOMMON reads and, where appropriate, writes a range of OPM and shared tables. Component and method masters (CM_CMPT_MST, CM_CMPT_DTL, CM_MTHD_MST, CM_RSRC_DTL, CM_ALYS_MST, CM_ACST_LED, CM_WHSE_ASC) provide cost-component, method, resource, and analysis definitions. Cost ledger and lot-cost tables (GL_ITEM_CST, GL_ITEM_DTL, GMF_LOT_COSTS, GMF_LOT_COST_DETAILS, GMF_MATERIAL_LOT_COST_TXNS) supply item and lot-level cost balances and transaction history. Batch context is drawn from GME_BATCH_HEADER and GME_MATERIAL_DETAILS. Fiscal and period context comes from GMF_FISCAL_POLICIES, GMF_PERIOD_BALANCES, GMF_PERIOD_STATUSES, and ORG_ACCT_PERIODS. Organizational mapping uses GMF_ORGANIZATION_DEFINITIONS and HR_ORGANIZATION_INFORMATION. Item, inventory, and UOM data are obtained from MTL_SYSTEM_ITEMS, MTL_ONHAND_QUANTITIES_DETAIL, MTL_SECONDARY_INVENTORIES, and MTL_UNITS_OF_MEASURE / MTL_UNITS_OF_MEASURE_VL. Currency or transfer pricing is handled via GMF_GET_TRANSFER_PRICE_PUB.

Usage Notes

GMF_CMCOMMON is invoked internally rather than directly by end users. It is called from OPM costing concurrent programs, batch cost rollup processes, and the numerous packages (22 documented dependents) that perform material and resource valuation. It relies on standard EBS utilities, including FND_API, FND_MSG_PUB, and FND_FILE for error handling and reporting, and on INV_CONVERT for unit-of-measure conversion. Customizations and extensions that calculate OPM costs should call these procedures rather than reimplementing rollup logic, ensuring consistency with the frozen-cost and fiscal-policy rules the package enforces.