Redwood: Specify Pricing Dates on Sales Orders

Your item's price might change over time but you need to honor the price commitment that you provide to your customer. For example, you need to price it on a future date, or the price might change between the time you create the original order and create a revision. You can now use the new Pricing Date attribute on the order header to specify the date that you want Oracle Pricing to use when it prices the order. Pricing will reference it to accurately determine the pricing strategy, price list, and discount list that are in effect on the Pricing Date according to their start date and end date:

xxxxxxxxx

Get more flexibility in the dates that you want Pricing to use when it prices your sales order.

Steps to Enable

Modify the Sales Service Mapping

Order Management sends the value from the order header's Ordered Date attribute through the mapping's PricedAsOf attribute, by default. You must modify the mapping so it sends the value from the order header's Pricing Date attribute instead:

xxxxxxxxxxxx

Try it:

  1. Go to the Pricing Administration work area, then click Tasks > Manage Service Mappings under Pricing Configuration. For background, see Manage Service Mapping.
  2. On the Manage Service Mappings page, query for, then open the Sales service mapping.
  3. On the Edit Service Mappings page, click Sources, then click the row that has OrderHeader in the Source column.
  4. In the OrderHeader Details area, on the Entity Mappings tab, click the row that has Header in the Entity column.
  5. In the Header Details area, on the Attribute Mappings tab, add this expression in the row that has PriceAsOf in the Attribute column:

    Attribute

    Expression

    PriceAsOf

    For background, see Manage Your Effectivity Dates.

    PricingDate != null ? PricingDate : OrderedDate

     

    Display Pricing Date on Classic Pages

    The Pricing Date attribute comes predefined to automatically display on the redesigned pages in the Pricing and Currency Section when you click Additional Order Details on the sales order. The attribute is hidden on the order header on the classic pages, so you must use Page Composer to display it. For background, see Modify How Order Management Displays Attributes.

Tips And Considerations

  • The Pricing Date attribute applies only for sales orders that Pricing prices through the Sales service mapping for Order Management. You can import the Pricing Date and Order Management will display it on the order header but it won't affect pricing for sales orders that Pricing does not price.
  • You can import the Pricing Date through the SalesOrdersforOrderHub or SalesOrdersforOrderHubRequests REST APIs, or through the SourceSalesOrderImportTemplate.xlsm FBDI template.

Key Resources

Administering Pricing

Access Requirements

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

  • Manage Service Mappings (QP_MANAGE_PRICING_SERVICE_MAPPINGS_PRIV)

This privilege was available before this update.