Search Results pmico_currconv_error

Overview

APPS.PMI_COMMON_PKG is a shared utility package body in the Oracle E-Business Suite Process Manufacturing (OPM) product family. Its name follows the OPM naming convention (PMI prefix), and it functions as a common library of cost, currency, and item-conversion routines consumed by other OPM and Oracle Process Manufacturing Cost Management components. The package is documented as VALID and classified as OTHER, meaning it is not an Oracle public API but an internal building block used by higher-level OPM programs.

Its primary business purpose is to encapsulate frequently used lookups and calculations that would otherwise be repeated across multiple OPM packages — most notably currency conversion and cost retrieval against OPM master data. By centralizing these operations, PMI_COMMON_PKG helps ensure consistent handling of multi-currency costing across the Process Manufacturing modules.

Key Procedures and Functions

The ETRM documentation lists six procedures/functions. Four are explicitly named and described here; parameter lists are not published in the metadata and are therefore not reproduced.

• PMICO_GET_COST — Retrieves cost information for OPM items, typically resolving the applicable cost for an item or component from the OPM costing tables. Likely used by cost rollup and cost calculation routines.
• PMICO_GET_MULCURR_AMT — "Multi-currency amount" retrieval. This routine resolves an amount expressed in a foreign currency into the appropriate reporting or functional currency, drawing on GL currency master data.
• PMICO_CURRCONV_ERROR — Handles currency conversion error conditions. This is likely a diagnostic or exception-handling routine that reports or logs a failure when a required exchange rate or currency conversion cannot be resolved.
• PMICO_GET_TARGET — Resolves a "target" value, most plausibly a target organization, warehouse, or item reference used in a costing or conversion context.

Two additional procedures/functions are documented in the count (six total) but are not individually named in the available metadata; their exact names and purposes cannot be stated without the full source listing.

Tables Accessed

The package body references four APPS synonyms, as listed in the ETRM dependency data:

• IC_ITEM_MST — OPM Item Master. Supplies item attributes used for cost and conversion lookups.
• IC_WHSE_MST — OPM Warehouse Master. Provides warehouse/organization context, particularly relevant to the PMICO_GET_TARGET routine.
• CM_CMPT_DTL — OPM Cost Management component detail. Supplies component-level cost data consumed by PMICO_GET_COST.
• GL_CURR_MST — General Ledger currency master. Provides currency and exchange-rate definition data required by PMICO_GET_MULCURR_AMT and PMICO_CURRCONV_ERROR.

By drawing on both OPM master tables and GL currency master, the package bridges process manufacturing costing with financial currency handling.

Usage Notes

PMI_COMMON_PKG is not invoked directly by end users. It is a subordinate library; the ETRM metadata confirms it is referenced by 13 other database objects (packages), making it a widely consumed internal utility. It is typically called from higher-level OPM Cost Management packages performing cost rollups, cost calculations, and multi-currency cost reporting. It may also be reached indirectly through OPM concurrent programs and cost-related forms.

Because the package body is not a public API and Oracle does not document a supported parameter signature, customizations should avoid calling it directly; custom code should instead invoke the sanctioned OPM APIs that in turn call this package. Any modification to its logic carries a high regression risk given its 13 dependent packages and its role in currency-sensitive costing.