CST Department Overhead Rate Upload – Oracle EBS SQL Report

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

Overview

CST Department Overhead Rate Upload ===================================

This upload can be used to

Department Overhead Rates associate Overhead sub-elements with Departments and specify the rate or amount charged, per basis (Item, Lot, Resource Units, or Resource Value). The rates are imported via the Oracle Cost Import Process.

NOTE: You can only upload rates to cost types that are not flagged as frozen and are flagged as updateable.

NOTE: The Cost Import Process cannot delete a Department Overhead Rate, so a row flagged for deletion is not sent to it. Set the Delete Overhead Rate column to Yes and the rate is removed directly when the row is processed, in the same way as the Overheads form removes it. Deletion is not allowed for frozen standard cost types or for cost types which do not allow updates. Deleted rates are not covered by the Cost Rollup. Run a rollup separately if the removal should be reflected in item costs.

NOTE: The Cost Import Process accepts only one row per Department, Overhead, and Cost Type combination in a single run, even when the rows carry different basis types. In ‘Remove and replace’ mode all existing basis rows of an uploaded combination are replaced by the uploaded row.

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

NOTE: In ‘All items’ mode the Supply Chain Cost Rollup requests are submitted asynchronously and the upload does not wait for them. In ‘Specific item’ mode, the items to roll up are derived from the existing cost details in the Target Cost Type. Items that have never been rolled up in the Target Cost Type are therefore not found, even if their routings use a department carrying an uploaded overhead rate - use ‘All items’ mode for those.

Parameters

Target Cost Type (Required) - The Cost Type to which the Department Overhead Rates are to be uploaded.

Mode (Required, Default: Remove and replace cost information) -

Auto Populate Upload Columns (Default: Yes) - Applies to downloaded rates 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.

Source Cost Type - Optionally specify the Cost Type from which to download the current Department Overhead Rates, to amend them or to copy them to a different Target Cost Type. New rates can be entered as additional rows in the generated Excel.

Rollup Costs - set to Yes to do a cost rollup after the rates are imported Rollup Type - All items or Specific item Rollup Option - Single level rollup or Full cost rollup

Organization Code / Department / Overhead - Optionally restrict the rates to be downloaded.

Notes on the Upload

The upload supports the Department Overhead Information descriptive flexfield. The attribute columns are named according to the descriptive flexfield segments setup.

Report Parameters

Target Cost Type, Mode, Auto Populate Upload Columns, Source Cost Type, Rollup Costs?, Rollup Type, Rollup Option, Organization Code, Department, Overhead

Oracle EBS Tables Used

cst_cost_types, mtl_parameters, bom_departments, bom_resources, cst_department_overheads, cst_activities, org_access_view

Report Categories

Enginatics, Upload

CAC Department Overhead Setup Errors, CAC Department Overhead Rates, CAC Resources Associated with Overheads Setup, CAC Department Overhead Setup, CAC Resources by Department Setup, CAC Item Cost & Routing, CAC WIP Account Detail, CAC Item Cost Break-Out by Activity, CAC ICP PII WIP Material Usage Variance

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_Department_Overhead_Rate_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/cst-department-overhead-rate-upload/

© 2026 Enginatics