Redwood: Create and Edit Item Cost Profiles Using a New User Experience

You can assign, update, and delete cost profiles to items at cost organization and cost book level by using item cost profiles. You can modify or delete a cost profile assignment at any time before transactions have been processed. You can't change the cost profile of an item after transactions are processed for the item. Item cost profiles can have three possible creation sources:

  • Automatic: Item cost profiles are automatically created using a default cost profile.
  • Manual: Item cost profiles are manually created using the Item Cost Profiles page. 
  • Override: Item cost profiles are automatically created using default cost profiles and later updated from the Item Cost Profiles page.

You can now create, modify, delete and search for item cost profiles using the Redwood pages. You can verify the existing item cost profiles and also download the information into a spreadsheet for offline analysis and collaboration. You can manage the item cost profiles only for the cost organizations that you've access to.

Search, Update and Delete Item Cost Profiles

On the Item Cost Profiles page, by default, you can view the manually created item cost profiles, which are sorted by cost organization, cost book, and item. You can further filter the records using:

  • Item
  • Cost Organization
  • Cost Book
  • Creation Source
  • Asset Cost Profile
  • Expense Cost Profile
  • Consigned Cost Profile

You can also view the details of the asset, expense, and consigned cost profiles by clicking the links in the respective columns. Additionally, you will also be able to view Asset UOM, Consigned UOM and Expense UOM in the Redwood page. You can also modify and delete any exiting item cost profile.

Item cost profiles page

Item cost profiles page

Create Item Cost Profile

Click the Add (+) button to create an item cost profile. You can see the details of the corresponding Asset, Expense, and Consigned cost profiles while you are creating the item cost profile.

Create item cost profile

Create item cost profile

Some of the benefits of this feature include:

  • Modernized, user-friendly interface for improved productivity.
  • Quickly review, assign and update cost profiles to items at the cost organization and cost book level.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

  • In the Setup and Maintenance work area, the Redwood version of the Item Cost Profiles page is enabled by default in this update, but the existing version of the Manage Item Cost Profiles page is still available in the Manufacturing and Supply Chain Materials Management offering. You should move to the Redwood version of the page at your earliest convenience, because the existing version of the page will be removed from the application in a future update.
  • You can provide guidance such as tutorials, company policies, and best practices in the context of item cost profiles using guided journey tasks. 
  • By default, you will see all the manually created item cost profiles sorted by cost organization, cost book, and item.
  • Based on nature of items, you can assign or update asset, expense, or consigned cost profiles to the items at the cost organization and cost book level.
  • The Manual filter shows records which include item cost profiles created manually and item cost profiles created automatically but later updated manually from the Item Cost Profiles page.
  • You won't be able to update or delete the item cost profiles for the item which has already been cost processed.
  • You will now be able to view Asset UOM, Consigned UOM, and Expense UOM in the Redwood page.

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 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 Item Cost Profile (CST_MANAGE_ITEM_COST_PROFILE)
  • Manage Item Cost Profile by Web Service (CST_MANAGE_ITEM_COST_PROFILE_WEB_SERVICE)