Upload Standard Overhead Rates Using REST Service

Create and edit overhead rates using the Standard Cost Overhead Rates REST service. The rates can then be used to roll up item standard costs.

The benefits of this feature include:

  • Enhanced Automation and Integration: The extended REST API functionality enables seamless integration with your existing systems and software. This automation not just improves overhead rate management but also ensures data consistency across your organization.
  • Improved Efficiency in Overhead Rate Management: With the new REST API capabilities for creating, updating, and deleting standard overhead rates, you can efficiently manage overhead rates by eliminating the need for manual data entry, reducing errors and saving time.
  • Increased Scalability and Agility: The ability to define overhead rates for multiple items using REST API provides your business with greater scalability and agility. You can easily adapt and manage overhead rates across a growing range of products, without being hindered by time-consuming manual processes. 

Steps to Enable

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

Tips And Considerations

  • The cost organization and cost book used to create the overhead rate should be associated with the cost scenario.
    • For supply chain cost rollup enabled cost scenarios, the cost organization and cost book should be part of the cost rollup group selected in the cost scenario.
    • You cannot establish overhead rates for cost scenarios associated with a periodic average cost book.
  • Overhead rates should be unique for a cost scenario.  
    •  A plant overhead rate should have unique combination of cost organization, cost book, effective start date, plant, item category, and item.
    •  A work center overhead rate should have unique combination of cost organization, cost book, effective start date, plant, work center, and resource type.
    • For a given overhead rate, the combination of cost element, expense pool, and absorption type should be unique.
    • In the case of plant overhead rates, you have the flexibility to create overhead rates either at the plant level or for a given product line or for a given product.
  • All validations that apply to the user interface are also relevant and applicable to the REST API.
  • Consider testing this REST API with varying data volumes to determine the most optimal batch size that aligns with your specific use case.

Key Resources

  • Oracle Fusion Cloud SCM: Using Supply Chain Cost Management guide, available on the Oracle Help Center.
  • Oracle Fusion Cloud SCM: REST API for Oracle Fusion Cloud SCM guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Manage Resource and Overhead Rates (CST_MANAGE_RESOURCE_OVERHEAD_RATES)

This privilege was available prior to this update.