Redwood: Do More Mass Actions on Price Lists

Starting in update 25B, you could apply mass actions on a redesigned page that simplified how you managed price lists. Now you can do more:

  • Use a scheduled process to apply mass actions.
  • Calculate price according to cost that you specify in the cost list.
  • Calculate price according to price in another price list.
  • Add items and calculate price across more than one price list.
  • Report errors across price lists.
  • Add an item that has a nonprimary UOM to your price list.
  • Create price in a nonprimary UOM on your price list.
  • Use descriptive flexfields with your items and charges.

Oracle Pricing uses the Process Mass Actions for Pricing scheduled process to manage a large volume of data on your price lists when you do an action in Pricing Administration or when you import batches of price lists or discount lists. For example, when you click Update on the Calculate Prices dialog:

xxxxxxxxxx

Or when you select more than one item in a price list and then do an action:

xxxxxxxxxxx

Or when you add items and calculate price across price lists:

xxxxxxxxxxxx

Do mass actions across more than one price list:

  • Filter according to the item's category, then select one or more items in that category.
  • Add items to more than one price list in a single step.

xxxxxxxxxxx

Calculate price according to cost:

  • Set up a calculation according to the item’s cost in a cost list.
  • Apply an amount, a percent markup, or percent discount.

xxxxxxxxx

Calculate price according to the price on another price list:

xxxxxxxxxxxxx

Add an item that has a nonprimary UOM. Add the item manually or through a UOM conversion:

xxxxxxxxxxxxxxx

Use a flexfield to store more details about the charge:

xxxxxxxxxxxxxx

Steps to Enable

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

Tips And Considerations

Object

Description

Reference Date

Applies when you do a mass action that calculates price according to an item’s cost in a cost list or price in another price list. The action will pick that item’s cost or the price that's in effect on the reference date.

Start Date

Use it to decide when the update goes into effect. If you don't enter a start date, then pricing assumes it's a direct update for that item’s price. If you enter a start date, then pricing will end date the existing price and create a new one.

Enter Prices Manually

The grid that you use when you click Enter Prices Manually can have a maximum of 1,500 rows. If you receive an error when you click it, then refine your search.

Calculate Prices

Pricing will immediately calculate up to 500 records when you click Calculate Prices. If there's more than 500, pricing automatically uses a scheduled process to calculate them.

Add Items

You can use the Add Items action across more than one price list only if the price lists are in the same business unit.

Calculate Prices

You can use the Calculate Prices dialog to calculate price for more than one price list only if the price lists are in the same business unit and have the same currency.

Mass Action Report

The Mass Action Report provides a summary of the process. It gives details about the errors. You can download the report from the Notifications Summary or from the Scheduled Processes work area.

Nonprimary UOM

To add it, go to the Add Items dialog, search for the item, select the nonprimary UOM, then add it to the item.

Key Resources

Access Requirements

  • Manage Draft Pricing Promotions (QP_MANAGE_DRAFT_PRICING_PROMOTIONS)
  • Manage Pricing Promotions (QP_MANAGE_PRICING_PROMOTIONS)
  • View Pricing Promotions (QP_VIEW_PRICING_PROMOTIONS)
  • Activate Pricing Promotions (QP_APPROVE_PRICING_PROMOTIONS)
  • Manage Pricing Rules (QP_MANAGE_PRICING_RULES)
  • Approve Discount Lists (QP_APPROVE_DISCOUNT_LISTS)
  • Manage Discount Lists (QP_MANAGE_DISCOUNT_LISTS)
  • Manage In-Progress Discount Lists (QP_MANAGE_IN_PROGRESS_DISCOUNT_LISTS)
  • View Discount Lists (QP_VIEW_DISCOUNT_LISTS)
  • View Price Lists (QP_VIEW_PRICE_LISTS_PRIV)
  • Manage Price Lists (QP_MANAGE_PRICE_LISTS_PRIV)
  • Manage In-Progress Price Lists (QP_MANAGE_IN_PROGRESS_PRICE_LISTS_PRIV)
  • Approve Price Lists (QP_APPROVE_PRICE_LISTS_PRIV)
  • Import Price Lists (QP_PRICE_LIST_IMPORT_PRIV)
  • Import Approved Price Lists (QP_PRICE_LIST_APPROVED_IMPORT_PRIV)
  • View Returns Price Lists (QP_VIEW_RETURNS_PRICE_LISTS_PRIV)
  • Manage Returns Price Lists (QP_MANAGE_RETURNS_PRICE_LISTS_PRIV)
  • Approve Returns Price Lists (QP_APPROVE_RETURNS_PRICE_LISTS_PRIV)
  • Manage In-Progress Returns Price Lists (QP_MANAGE_IN_PROGRESS_RETURNS_PRICE_LIST_PRIV)

These privileges were available before this update.