Search Results get_uom_conv_rate

Overview

APPS.CSTPPCIC is a cost management package body within the Oracle E-Business Suite Cost Management (CST) module. Its two documented entry points address distinct functional areas: unit-of-measure conversion resolution for inter-org item transfers, and the bulk copying of item period costs between cost types, cost groups, and organizations. Because the package source header dates from 2005 and carries the "noship" designation, the unit is best understood as an internal utility package rather than a public, supported API surface.

In Oracle EBS 12.1.1 and 12.2.2, the package is registered under the APPS schema with an API classification of OTHER. The ETRM metadata documents exactly two procedures/functions, and the package is referenced by zero other packages, indicating it is invoked directly by concurrent programs or forms rather than being called programmatically from other PL/SQL units.

Key Procedures and Functions

GET_UOM_CONV_RATE — Returns the conversion rate applicable to an item when moving between a source organization and a destination organization. It does so by first determining the shipping and receiving units of measure for the item in the two organizations, then resolving the conversion factor between those units for that specific item. This is the function a user reaching for "get_uom_conv_rate" is looking for: it encapsulates the two-step resolution of org-specific UOMs plus the item-specific conversion rate, sparing callers from orchestrating those lookups themselves.

COPY_ITEM_PERIOD_COST — Performs the bulk transfer of item period costs from a source cost type, cost group, and period into a destination organization and cost type. Its documented behavior includes a copy option that governs merge semantics (merge and update, new cost only, or remove and replace) and a range parameter that scopes the operation to all items, a specific item, or the items belonging to a category. The procedure also applies documented defaults to the cost rows it creates, including a defaulted flag that suppresses default cost controls, a null cost update identifier, and a rollup flag and basis factor that mark the copied costs as user-defined rather than rollup-derived.

Tables Accessed

The package reads and writes cost data primarily through CST_ITEM_COSTS, CST_ITEM_COST_DETAILS, and their interface and PAC counterparts (CST_ITEM_COSTS_INTERFACE, CST_PAC_ITEM_COSTS, CST_PAC_ITEM_COST_DETAILS). Cost type and group context is resolved from CST_COST_TYPES, CST_COST_GROUPS, CST_COST_GROUP_ASSIGNMENTS, and CST_LE_COST_TYPES. Period definition data comes from CST_PAC_PERIODS and CST_PAC_PROCESS_PHASES, while CST_LISTS_S supports list-based processing. Item categorization and organizational setup are drawn from MTL_ITEM_CATEGORIES, MTL_PARAMETERS, and BOM_RESOURCES. All access occurs through APPS synonyms.

Usage Notes

GET_UOM_CONV_RATE is typically called during inter-organization transfer costing, where the correct conversion between shipping and receiving UOMs must be applied to value the transaction. COPY_ITEM_PERIOD_COST is characteristically invoked from cost-copy concurrent programs or from the cost maintenance forms in the Cost Management responsibility, where the copy option and range parameters map directly to user-selected form values. Because the package is internal (noship header, OTHER classification, zero documented dependents), custom code should treat both entry points as unsupported: validate behavior in a test instance and prefer supported alternatives such as INV_CONVERT for conversion math wherever feasible.