Search Results copy_item_period_cost

Overview

CSTPPCIC is a PL/SQL package in the Oracle E-Business Suite Cost Management (CST) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its central business function is to copy item period costs from a source cost type and cost group within a period into a destination inventory organization and cost type, populating the CST_ITEM_COSTS table and associated detail structures. This is the programmatic engine behind the "Copy Item Costs" capability used during cost rollup, cost simulation, standard costing updates, and period-close activities in Oracle EBS 12.1.1 and 12.2.2.

The header comment dates the source at version 115.7 (2002), reflecting a long-standing, stable utility that remains part of the released Cost Management schema. In the 12.2.2 ETRM metadata, the package is classified as a public API of type OTHER, exposing two documented program units: GET_UOM_CONV_RATE and COPY_ITEM_PERIOD_COST.

Key Procedures and Functions

• GET_UOM_CONV_RATE — A function returning a numeric conversion rate between two units of measure for a specified item, from a source inventory organization to a target organization. The returned rate is multiplied by the source cost to derive the destination cost inserted into CST_ITEM_COSTS by COPY_ITEM_PERIOD_COST. It reconciles UOM differences when costs move between organizations that maintain different primary or costing units of measure.
• COPY_ITEM_PERIOD_COST — The public procedure that performs the actual cost copy. It accepts parameters controlling the legal entity, source cost type and cost group, source period, destination organization, destination cost type, and cost element flags (material, material overhead, resource, outside processing, overhead). It further accepts a p_copy_option governing merge/update, new-cost-only, or remove-and-replace behavior, and a p_range governing all items, a specific item, or category items. Additional parameters address category set/structure selection and validation, last-updated-by auditing, and full validation. It returns the standard concurrent-program errbuf and retcode OUT parameters.

Tables Accessed

The package references the following objects via APPS synonyms. CST_ITEM_COSTS and CST_ITEM_COST_DETAILS are written with the copied costs and their element-level detail. CST_PAC_ITEM_COSTS and CST_PAC_ITEM_COST_DETAILS hold PAC (period-average cost) equivalents. CST_PAC_PERIODS supplies period context, and CST_PAC_PROCESS_PHASES tracks processing state. CST_COST_TYPES, CST_COST_GROUPS, CST_COST_GROUP_ASSIGNMENTS, and CST_LE_COST_TYPES validate and resolve source/destination cost structures and legal-entity mappings. CST_LISTS_S and CST_ITEM_COSTS_INTERFACE support list and interface processing. BOM_RESOURCES and MTL_ITEM_CATEGORIES provide resource and item-category data for selection and conversion logic, while MTL_PARAMETERS supplies organization-level costing parameters.

Usage Notes

CSTPPCIC is typically invoked from the Cost Management concurrent programs and cost-copy forms that pass the source period, cost type, and destination organization. The errbuf/retcode signature confirms it is designed to run as a concurrent executable, making it callable directly from a concurrent program definition or from custom PL/SQL that submits it through the concurrent manager. Because it is a released APPS API, custom code should call COPY_ITEM_PERIOD_COST rather than inserting into CST_ITEM_COSTS directly, preserving the UOM conversion, element allocation, and validation logic. The metadata records zero packages referencing it, indicating it is a top-level entry point rather than a dependency of other released APIs.