Search Results gmf_cmcommon
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.
-
SYNONYM: APPS.GL_ITEM_DTL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GL_ITEM_DTL, status:VALID,
-
SYNONYM: APPS.GL_ITEM_CST
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GL_ITEM_CST, status:VALID,
-
SYNONYM: APPS.GL_ITEM_DTL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GL_ITEM_DTL, status:VALID,
-
SYNONYM: APPS.GL_ITEM_CST
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GL_ITEM_CST, status:VALID,
-
SYNONYM: APPS.CM_WHSE_ASC
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CM_WHSE_ASC, status:VALID,
-
PACKAGE BODY: APPS.GMF_CMCOMMON
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_CMCOMMON, status:VALID,
-
SYNONYM: APPS.GMF_LOT_COST_DETAILS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMF_LOT_COST_DETAILS, status:VALID,
-
SYNONYM: APPS.GMF_LOT_COST_DETAILS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_LOT_COST_DETAILS, status:VALID,
-
SYNONYM: APPS.CM_ALYS_MST
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CM_ALYS_MST, status:VALID,
-
SYNONYM: APPS.GMF_FISCAL_POLICIES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_FISCAL_POLICIES, status:VALID,
-
PACKAGE BODY: APPS.GMF_CMCOMMON
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_CMCOMMON, status:VALID,
-
SYNONYM: APPS.CM_WHSE_ASC
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CM_WHSE_ASC, status:VALID,
-
SYNONYM: APPS.CM_ALYS_MST
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CM_ALYS_MST, status:VALID,
-
PACKAGE: APPS.GMF_CMCOMMON
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMF_CMCOMMON, status:VALID,
-
SYNONYM: APPS.GMF_FISCAL_POLICIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMF_FISCAL_POLICIES, status:VALID,
-
PACKAGE: APPS.GMF_CMCOMMON
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMF_CMCOMMON, status:VALID,
-
SYNONYM: APPS.CM_CMPT_MST
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CM_CMPT_MST, status:VALID,
-
SYNONYM: APPS.CM_CMPT_MST
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CM_CMPT_MST, status:VALID,
-
SYNONYM: APPS.GMF_LOT_COSTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMF_LOT_COSTS, status:VALID,
-
SYNONYM: APPS.CM_ACST_LED
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CM_ACST_LED, status:VALID,
-
SYNONYM: APPS.GMF_PERIOD_BALANCES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_PERIOD_BALANCES, status:VALID,
-
PACKAGE BODY: APPS.MTL_ABC_COMPILE_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:MTL_ABC_COMPILE_PKG, status:VALID,
-
PACKAGE BODY: APPS.PMI_COMMON_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PMI_COMMON_PKG, status:VALID,
-
PACKAGE BODY: APPS.PO_POXRCPPV_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PO_POXRCPPV_XMLP_PKG, status:VALID,
-
SYNONYM: APPS.CM_ACST_LED
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CM_ACST_LED, status:VALID,
-
SYNONYM: APPS.GMF_LOT_COSTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_LOT_COSTS, status:VALID,
-
SYNONYM: APPS.GMF_MATERIAL_LOT_COST_TXNS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:GMF_MATERIAL_LOT_COST_TXNS, status:VALID,
-
PACKAGE BODY: APPS.GML_RQ_DB_COMMON
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GML_RQ_DB_COMMON, status:VALID,
-
PACKAGE BODY: APPS.GMICDEP
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMICDEP, status:VALID,
-
PACKAGE: APPS.GMF_GET_TRANSFER_PRICE_PUB
12.1.1
owner:APPS, object_type:PACKAGE, object_name:GMF_GET_TRANSFER_PRICE_PUB, status:VALID,
-
PACKAGE BODY: APPS.GMF_GMFINVAL_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_GMFINVAL_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.INV_VIEW_MTL_TXN
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:INV_VIEW_MTL_TXN, status:VALID,
-
PACKAGE BODY: APPS.MTL_ABC_COMPILE_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:MTL_ABC_COMPILE_PKG, status:VALID,
-
PACKAGE BODY: APPS.GMICDEP
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMICDEP, status:VALID,
-
SYNONYM: APPS.GMF_MATERIAL_LOT_COST_TXNS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:GMF_MATERIAL_LOT_COST_TXNS, status:VALID,
-
PACKAGE BODY: APPS.GME_GMEMUSBV_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GME_GMEMUSBV_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.GML_RQ_DB_COMMON
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GML_RQ_DB_COMMON, status:VALID,
-
PACKAGE BODY: APPS.PO_POXRCPPV_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PO_POXRCPPV_XMLP_PKG, status:VALID,
-
PACKAGE: APPS.GMF_GET_TRANSFER_PRICE_PUB
12.2.2
owner:APPS, object_type:PACKAGE, object_name:GMF_GET_TRANSFER_PRICE_PUB, status:VALID,
-
PACKAGE BODY: APPS.GMF_PROCESS_COST_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_PROCESS_COST_PUB, status:VALID,
-
PACKAGE BODY: APPS.GMI_ICR03_XMLP_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMI_ICR03_XMLP_PKG, status:VALID,
-
PACKAGE BODY: APPS.GME_REOPEN_BATCH_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GME_REOPEN_BATCH_PVT, status:VALID,
-
PACKAGE BODY: APPS.GMF_PROCESS_COST_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:GMF_PROCESS_COST_PUB, status:VALID,
-
PACKAGE BODY: APPS.OPI_DBI_INV_CCA_OPM_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_DBI_INV_CCA_OPM_PKG, status:VALID,
-
PACKAGE BODY: APPS.GMP_APS_OUTPUT_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMP_APS_OUTPUT_PKG, status:VALID,
-
PACKAGE BODY: APPS.GMD_LCF_FETCH_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GMD_LCF_FETCH_PKG, status:VALID,
-
PACKAGE BODY: APPS.OPI_OPM_COMMON_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OPI_OPM_COMMON_PKG, status:VALID,
-
SYNONYM: APPS.CM_RSRC_DTL
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CM_RSRC_DTL, status:VALID,
-
SYNONYM: APPS.CM_RSRC_DTL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CM_RSRC_DTL, status:VALID,
-
PACKAGE BODY: APPS.GME_GMEBCHYV_XMLP_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:GME_GMEBCHYV_XMLP_PKG, status:VALID,