CST Item Standard Cost Upload loads and revises item standard costs in an updateable, non-frozen standard cost type from Excel. It stages this-level elemental costs and runs Oracle’s Cost Import Process, and can optionally run a cost rollup afterwards. Download the current costs of a source cost type to amend them, or to copy them into another cost type, or start from an empty sheet to enter new item costs.

When to use it

  • Load new item costs into a pending or simulation cost type before a standard cost update.
  • Download the current costs of a cost type, amend them in Excel and upload them back.
  • Copy the costs of one cost type into another, with or without changes.
  • Roll up the costs of the uploaded items, or of all items, right after the import.

Before you start

  • Your responsibility has access to the inventory organizations whose costs you load.
  • The target cost type uses the standard costing method, allows updates, is not frozen and not disabled. Frozen standard costs are changed by a standard cost update, not by this upload.
  • The items are costing enabled, and the sub-elements, activities and bases you enter exist in the organization.

Step 1 – Set the parameters

Open CST Item Standard Cost Upload in Blitz Report and set the parameters:

ParameterMeaning
Target Cost TypeThe cost type the costs are imported into. Lists updateable, non-frozen standard cost types only.
ModeRemove and replace cost information (default) rebuilds each uploaded item’s costs in the target cost type from the uploaded rows; Insert new cost information only adds costs only for items that have none in the target cost type yet.
Auto Populate Upload ColumnsYes (default) marks every downloaded row for upload even if you do not change it. Blank marks only the rows you edit.
Source Cost TypeThe cost type whose current costs are downloaded. Enter the target cost type itself to amend its costs, or another cost type to copy its costs. Leave it blank for an empty sheet.
Rollup Costs? / Rollup Type / Rollup OptionYes runs a cost rollup after a successful import. Rollup Type Specific item rolls up the uploaded items in the upload request, All items submits a Supply Chain Cost Rollup request per organization. Rollup Option is a single level or full cost rollup.
Organization Code, Category Set, Category, Item, Item Like, Item Description, Item Type, Excluded Item Statuses, Make or Buy, Buyer, PlannerRestrict the items downloaded.
Inventory Asset?Yes (default) downloads only items that are an inventory asset in the source cost type, as costs can only be imported for those. Clear it to also download expense items, so you can set Inventory Asset to Yes and enter their costs.
Based on Rollup? / Zero Cost Items?Restrict the download to rolled-up or not rolled-up items, and to items with or without a cost. Zero cost items without cost details download with a Material row and a zero rate to fill in.
Blitz Report run screen for CST Item Standard Cost Upload with Target and Source Cost Type Pending, Mode Remove and replace cost information, Organization Code M1 and Item Like CM8832%

Step 2 – Run to download the Excel file

Click Run. The Excel file downloads and opens with one row per this-level cost element of each item, or an empty sheet when no Source Cost Type is set.

Excel file with the Material cost elements of items CM88321 and CM88326 from the Pending cost type

Step 3 – Enter or change the costs

Each row is one this-level cost element of an item. Organization Code and Item identify the item; Inventory Asset, Based On Rollup, Lot Size and Shrinkage Rate apply to the whole item. Per row, enter the Cost Element, Sub-Element, Usage Rate Or Amount and Basis, and where used the Activity, Activity Units and Item Units. To add costs for a new item, add rows with these columns. The unit cost, resource rate and item cost summary columns are calculated by the import and refreshed in the result.

In Remove and replace mode the import replaces all this-level cost details of an uploaded item in the target cost type, so upload every cost element row of the item together: an element row you delete or leave unmarked is removed from the item’s costs.

Excel file with the Material rate of CM88326 changed to 1.25, marked Update, and a new Material cost of 0.05 for item CM16101, marked Create

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and saves the file. Correct any rows it flags before uploading.

All three rows show status Valid after Validate and Save

Step 5 – Upload the file

In Blitz Report click Upload and select the saved file. This submits the upload request, which stages the rows in the item cost interface, runs the Cost Import Process for the target cost type and then the cost rollup, if requested.

File Upload page with the saved Excel file selected for upload

Step 6 – Review the result report

When the request completes, a result report opens listing the imported cost elements with their calculated unit and item costs, and any rejected rows with the import’s error message.

Result report showing the imported costs of CM16101, CM88321 and CM88326 with status Success and the completed Item Cost Import request

What’s produced

  • Item costs created or replaced in the target cost type, optionally rolled up.
  • A result report listing every row with a status (success or error) and a message.

Common questions

Why is my cost type not in the Target Cost Type list?
Only cost types with the standard costing method that allow updates, are not frozen and not disabled are listed. Cost types restricted to one organization appear only if your responsibility has access to it.

Why is the downloaded sheet empty?
Costs are downloaded from the Source Cost Type; without it the sheet is empty. Also check the Inventory Asset? filter, and note that items whose costs default from the Default Cost Type have no costs of their own in the source cost type and are not downloaded.

I changed one cost element – will the item’s other elements be kept?
In Remove and replace mode only if their rows are uploaded too. With Auto Populate Upload Columns Yes (default) all downloaded rows are uploaded; if you clear it, mark every element row of the item, or the unmarked elements are deleted.

Can I upload rolled-up costs?
No. Oracle’s item cost interface imports this-level costs only. Use the rollup option to derive the previous-level costs of assemblies.

Which items are rolled up?
Items with Based On Rollup Yes. The rollup runs only after a successful import. With Rollup Type All items the upload does not wait for the rollup requests, so the result report can show item costs from before the rollup.

Troubleshooting

MessageCauseWhat to do
Rollup Type and Rollup Option must be specified in order to Rollup CostsRollup Costs? is Yes but Rollup Type or Rollup Option is blank.Set both, or clear Rollup Costs?.
Item Cost Import not Submitted due to “…”The Cost Import Process request could not be submitted.Check the quoted reason and that your responsibility can submit the program.
Item Cost Import Request … completed ErrorThe Cost Import Process ended in error.Review the log of the named request, correct the rows and upload again.
Row-level error from the import (for example an invalid sub-element, basis or item)Oracle’s import rejected the staged row; the row is shown with status Error and the import’s message.Correct the value in the result file and upload it again; the corrected row replaces the rejected interface row.
Warning: Cost Roll Up has failed for one or more items. Please review the log file of request … for detailsThe costs were imported, but the rollup failed for some items.Review the named request log, fix the bill or routing and run the rollup again.
Warning: Supply Chain Cost Rollup request not submitted due to “…”The All items rollup request could not be submitted.The costs were imported; run the Supply Chain Cost Rollup manually.