Results for “pmico_get_cost”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PMI_COMMON_PKG is a shared utility package in the APPS schema of Oracle E-Business Suite, serving as a common library for the Process Manufacturing Intelligence (PMI) reporting and summarization components. Its name reflects its role: a single, centralized repository of the low-level logic reused across the PMI analytics views, summary build programs, and sales reporting subprograms. Rather than duplicating currency conversion, costing, and unit-of-measure handling in every report, the PMI development team consolidated these operations here so that the dependent views (PMIFV_BATCH_DETAILS_V, PMIFV_BATCH_INPUT_V, PMIFV_BATCH_TRANS_V, PMIFV_PROD_EFFI_V, PMIFV_SALES_DETAILS_V, PMI_REP_EXP_INVENTORY_V, PMI_REP_GROSS_MARGIN_V, PMI_REP_PROD_STATUS_V, and PMI_REP_SALES_DETAILS_V) and the summary builders (PMI_BUILD_ONHANDSALE_SUM, PMI_BUILD_PROD_SUM, and PMI_PRODUCTION_SUM) inherit consistent behavior. The package is documented as VALID in both EBS 12.1.1 and 12.2.2 environments, and the ETRM classification for the package is OTHER, indicating it exposes no publicly supported API surface beyond its internal PMI consumers.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions. No parameter lists are published, so only purposes are described here.

• PMICO_GET_COST — Retrieves the cost associated with a process manufacturing item or transaction. This is the costing primitive that feeds gross margin and production efficiency reporting, returning the value that downstream views treat as the standard or actual cost.
• PMICO_GET_MULCURR_AMT — Returns an amount adjusted for multiple currencies. It allows PMI reports to express values in a currency other than the transaction or ledger currency, which is essential when consolidating operations across differing currency environments.
• PMICO_CURRCONV_ERROR — Handles currency conversion error conditions. It is invoked when a rate is missing, a conversion is invalid, or the multi-currency retrieval cannot complete, giving the calling views and summaries a controlled path instead of an unhandled exception.
• PMICO_GET_TARGET — Obtains a target value used for performance comparison, such as a planned or budgeted production target. It supplies the denominator or reference figure used in efficiency calculations.
• The remaining two documented procedures follow the same PMICO_ prefix convention and provide supporting utility logic within the same currency, cost, or target domain.

Tables Accessed

The package reads four tables through APPS synonyms:

• GL_CURR_MST — the General Ledger currency master, supplying currency definitions and conversion context needed by PMICO_GET_MULCURR_AMT and PMICO_CURRCONV_ERROR.
• CM_CMPT_DTL — the cost management component detail table, providing the cost components that PMICO_GET_COST resolves into a usable cost figure.
• IC_ITEM_MST and IC_WHSE_MST — the inventory item master and warehouse master, providing item and warehouse attributes that the target and cost routines use to qualify their lookups. These tables are synonym references to the underlying Process Manufacturing (formerly OPM) inventory tables, so the package addresses them through the APPS synonyms rather than direct schema-qualified names.

Usage Notes

PMI_COMMON_PKG is invoked indirectly rather than directly. Its principal callers are the thirteen dependent objects listed in the dependency tree: the PMIFV views and PMI_REP views resolve it when queried, and the summary build packages (PMI_BUILD_ONHANDSALE_SUM, PMI_BUILD_PROD_SUM, PMI_PRODUCTION_SUM) and PMI_SALES_PKG call it during concurrent-program execution. The package also references itself, indicating internal recursion or shared helper calls between its own subprograms. Because it is not classified as an Open Interface or public API, customizations should not call PMICO_ routines directly; the supported extension point is the reporting views and summary programs that depend on it. When troubleshooting PMI reports, the most common failure mode is a currency conversion error raised by PMICO_CURRCONV_ERROR, which typically points to a missing GL daily rate, while unexpected cost or target values usually trace to the item and warehouse records in IC_ITEM_MST and IC_WHSE_MST. Any change to this package requires recompilation of all thirteen dependent objects, since the views and packages are invalidated by dependency.