CST Item Standard Cost Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

CST Item Standard Cost Upload =============================

This upload can be used to

NOTE: You can only upload costs to cost types that are not flagged as frozen and are flagged as updateable. This upload is used for updating cost types using the standard costing method.

Optionally, the upload can perform a Cost Rollup after the Item Costs have been imported. The Cost Rollup can be performed for

NOTE: The Item Cost Interface only supports importing ‘This Level’ costs. As such, this upload does not support the direct upload of rolled up costs

Parameters

Target Cost Type (Required) - The Cost Type to which the Item Costs are to be uploaded to.

Mode (Required, Default: Remove and replace cost information) - The Item Cost Update Mode

Auto Populate Upload Columns (Default: Yes) - Applies to downloaded Item Cost Entries only. If set to Yes, the downloaded records are flagged ready for upload even if no changes have been made. If left blank, records are only flagged for upload when the user amends them. Where an Item Cost has multiple cost elements, all cost element records of that item must then be flagged for upload by amending them, as only flagged records are uploaded.

Source Cost Type Optionally specify the source Cost Type from which to download the current Item Costs. For the scenarios where you want to amend the current items costs for a Cost Type or want to copy the current item costs for a Cost Type to a different Target Cost Type.

Rollup Costs - set to Yes to do a cost rollup after the costs are uploaded Rollup Type - Rollup specific Items or All Items Rollup Option - Single level rollup or Full cost rollup

NOTE: In All Items mode the Supply Chain Cost Rollup requests are submitted asynchronously, and the upload does not wait for them, so the item summary costs in the upload result may not yet reflect the completed rollup.

Organization Code - Optionally select the Organization(s) for which you want to download the Item Costs for Additional Parameters - optionally restrict the items to be downloaded.

Inventory Asset? (Default: Yes) Costs can only be uploaded against items flagged as an inventory asset in the cost type, so others are excluded by default. Select No or clear it to download them, so the flag can be set to Yes and costs entered. On Release 12.1 and earlier the item must also be set as an inventory asset in the selected organization, or the import rejects it.

Based on Rollup? and Zero Cost Items? further restrict the download. Zero cost items include those with no cost details yet, which download with Cost Element, Sub-Element and Usage Rate or Amount defaulted.

Notes on the Upload

Mode Remove and replace rebuilds the whole item: the import deletes every cost detail the item holds in the cost type and re-creates it from the uploaded rows. All cost element rows of an item must therefore be uploaded together, which Auto Populate Upload Columns Yes ensures; clear it and amend one element only and the rest are deleted. Deleting a row removes that cost element.

Items whose costs default from the Default Cost Type have no cost details of their own, so they are not downloaded. Uploading costs against such an item gives it its own costs and it stops defaulting.

Report Parameters

Target Cost Type, Mode, Auto Populate Upload Columns, Source Cost Type, Rollup Costs?, Rollup Type, Rollup Option, Organization Code, Category Set, Category, Item, Item Like, Item Description, Item Type, Excluded Item Statuses, Make or Buy, Buyer, Planner, Inventory Asset?, Based on Rollup?, Zero Cost Items?

Oracle EBS Tables Used

mtl_item_status_vl, cst_cost_elements, bom_resources, cst_cost_types, cst_item_costs, cst_item_cost_details, cst_activities, mtl_system_items_vl, mtl_parameters, org_access_view

Report Categories

Enginatics, Upload

CAC Item Cost & Routing, CST Detailed Item Cost, CAC Load More4Apps Buy Item Costs, CAC Item Cost Break-Out by Activity, CAC Material Account Detail, CAC ICP PII Material Account Detail, CAC Resource Costs, CAC Last Standard Item Cost, CAC Cost vs. Planning Item Controls

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output
Blitz Report™ XML Import CST_Item_Standard_Cost_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/cst-item-standard-cost-upload/

Executive Summary

The CST Item Standard Cost Upload is a specialized tool for managing Standard Costs in Oracle EBS. It extends the capabilities of the basic cost upload by adding features specifically designed for the standard costing lifecycle, such as the ability to trigger a “Cost Rollup” directly after upload. This ensures that when component costs are updated, the parent assembly costs are immediately recalculated to reflect the change.

Business Challenge

Solution

This tool provides a seamless “Download -> Update -> Upload -> Rollup” workflow.

Key Features:

Architecture

The tool populates the standard interface tables and then calls the Cost Rollup API.

Key Tables:

Impact

© 2026 Enginatics