Search Results gmca_iuomcv

Overview

PMI_COST_ANALZ_PACK is a Process Manufacturing cost analysis package in Oracle EBS Applications (APPS schema), delivered under the ETRM/Process Manufacturing Intelligence module. It provides the PL/SQL foundation used to calculate, retrieve, and validate costing data associated with process manufacturing batches, formulas, inventory balances, and warehouse cost components. The package is defined with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking session rather than the definer, which allows it to be safely called from report, form, and concurrent program contexts where the calling user's organization and security context must be honored.

The package maintains a set of package-level global variables (such as Pkg_var_Batch_id, Pkg_var_Scale_factor_v, material quantity and UOM holders, and Pkg_var_all_linear) that persist state across function calls within a session. These globals support batch-scaling and material quantity calculations that recur throughout the cost analysis logic. The header identifies the source file as PMICTANS.pls, confirming its lineage within the Process Manufacturing cost analysis family.

Key Procedures and Functions

• GMCA_GET_COST — Retrieves the cost of an item for a given inventory warehouse, cost method, and cost date. It is the core valuation primitive used by downstream variance and balance logic.
• GMCA_GET_PERBAL — Returns the periodic balance for a specific item, warehouse, and organization on a given transaction date, drawing on the inventory period balance tables.
• GMCA_GET_LINE_TYPE — Derives the line type classification for an item, used to distinguish material categories during cost rollup and variance determination.
• GMCA_INV_PEREND — Computes the inventory period end date for a supplied organization, fiscal year, and accounting period, based on the inventory calendar.
• GMCA_VARIANCE — Calculates cost or quantity variance for a batch material line, accepting batch, formula, material, cost method, planned quantity, UOM, line type, line number, batch status, completion and close dates, and warehouse context. This is the most parameter-rich function in the package.
• GMCA_GET_ONHANDQTY — Returns the on-hand quantity for an item, typically for a specified warehouse or organization.
• GMCA_GET_MEANING — Resolves a lookup code to its user-facing meaning, enabling reports and forms to present decoded values. This is the function most relevant to users searching for descriptive lookup resolution.
• GMCA_IUOMCV — Performs inventory unit-of-measure conversion, translating quantities between the item's primary UOM and an alternate UOM.
• GMCA_UOMCV — Provides general unit-of-measure conversion between specified UOM codes.
• GMCA_COST_WHSE — Determines or validates the cost warehouse applicable to a given costing context.
• GMCA_WHSE_CURRENCY — Returns the currency associated with a warehouse, supporting multi-currency valuation of cost components.

Tables Accessed

• GME_BATCH_HEADER, GME_MATERIAL_DETAILS — Batch and material line data supplying batch ID, status, completion and close dates, planned quantities, and line attributes for variance calculation.
• FM_FORM_MST, FM_MATL_DTL — Formula master and material detail definitions used to compare planned versus actual consumption.
• CM_CMPT_DTL, CM_CLDR_HDR, CM_CLDR_DTL, CM_WHSE_ASC — Cost component detail, costing calendar, and warehouse association tables underpinning cost method and cost date resolution.
• IC_ITEM_MST, IC_PERD_BAL, IC_CLDR_DTL, IC_LOCT_INV, IC_WHSE_MST — Inventory item master, period balances, inventory calendar, location inventory, and warehouse master used for cost, balance, on-hand, and period-end calculations.
• SY_ORGN_MST, SY_UOMS_MST — Organization and unit-of-measure master tables supporting organizational context and UOM conversion.

Usage Notes

PMI_COST_ANALZ_PACK is typically invoked from Process Manufacturing cost analysis reports, batch costing forms, and custom cost rollup logic. Its 12 dependent packages indicate it is a foundational utility layer rather than a standalone entry point; callers should establish the required organization and batch context before invoking cost, balance, or variance functions, since package globals retain session state. Because the package uses AUTHID CURRENT_USER, callers must possess the necessary privileges on the referenced APPS synonyms. GMCA_GET_MEANING and the UOM conversion functions are commonly reused in custom extensions that need decoded lookup values or UOM-normalized quantities alongside the standard costing results.