1. Implementing Order Management
  2. Specify Pricing Dates on Sales Orders

Specify Pricing Dates on Sales Orders

Use a Redwood page to 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 use the 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.

Set Up

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

  1. Go to the Pricing Administration work area, then click Tasks > Manage Service MappingsunderPricing Configuration. For background, see Manage Service Mappings.
  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 Pricing's Effectivity Dates.

    		 
    PricingDate != null ? 
PricingDate : OrderedDate

Guidelines

  • 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.

For more, see Redwood: Specify Pricing Dates on Sales Orders.