Redwood: Perform Mass Edit of Overhead Rates

Overhead rates indicate the indirect costs associated with producing an item and represent one of the key input parameters to a cost scenario. You can define the overhead rates as:

  • Plant Overhead: Plant overheads, such as lighting and cooling, can be absorbed based on the material cost. They can be of a fixed or percentage value, with different absorption types available.
  • Work Center Overhead: Work center overheads, such as security, are absorbed by the finished goods based on a fixed rate or a percentage of resource cost incurred in the work center.

You can now select multiple unpublished overhead rates and simultaneously edit the selected overhead rates from the Overhead Rates Redwood page. You can:

  • Increase cost
  • Decrease cost
  • Replace cost
  • Add cost element
  • Delete cost element
  • Substitute cost element
  • Substitute expense pool

You can only use cost elements of type Overhead.

Screenshot with Mass Edit Capability

Screenshot with Mass Edit Capability

Some of the benefits of this feature include:

  • Improves operational efficiency by enabling users to update multiple overhead rates simultaneously, which significantly reduces the time and effort required for routine rate maintenance.
  • Enhances cost control and profitability by ensuring overhead rates are quickly and accurately updated in response to business changes, supporting better decision making, and financial planning.

Steps to Enable

  1. In the Setup and Maintenance work area, search for and select the Manage Administrator Profile Values task.
  2. On the Manage Administrator Profile Values page, search for and select the ORA_CST_STD_OVERHEAD_RATE_REDWOOD_ENABLED profile option code.
  3. In the Profile Values section, set the Site level to Yes. The default value is No.
    • Yes = enables the feature
    • No = disables the feature.
  4. Click Save and Close. Changes in the profile value will affect users the next time they sign in.

After you've set the profile value correctly, the task pane under Cost Accounting will show the task menu link as Overhead Rates. Using this link, you can access the Redwood page. You can also navigate to the Redwood page directly from the actions menu of the cost scenario.

Tips And Considerations

  • You can only update the overhead rates in the In process status. Overhead rates in the Published status can't be updated.
  • You can perform mass edit only for cost elements of the type Overhead.
  • When you perform the mass edit, if any selected record fails validation, none of the selected records will be updated.

Key Resources

  • Oracle Fusion Cloud SCM: Implementing Manufacturing and Supply Chain Materials Management guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: Using Supply Chain Cost Management guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains the following privilege can access this feature:

  • Manage Resource and Overhead Rate Plans (CST_MANAGE_RATE_PLANS)