1. Scheduled Processes for SCM
  2. Update Sales Order Totals

Update Sales Order Totals

Use the Update Sales Order Totals scheduled process when you need to recalculate totals and sub totals for sales orders.

When to Use

  • Run this scheduled process when your sales order is missing some or all of its total values, or when the totals on the order header don't match the price on the order lines.
  • Run it only when your sales order is missing some or all of the order total.
  • You can also run it when you use the dual units of measure feature. Use it when your sales order contains an item that you price in the secondary UOM but the secondary ordered quantity doesn't match the secondary shipped quantity. For details, see Overview of Setting Up Dual Units of Measure.
  • Don't run this scheduled process to update the sales order total when you reprice the sales order through any pricing system that isn't Oracle Pricing, such as a custom task in your orchestration process that references a fulfillment system that resides outside of Oracle.

Privileges Required

  • Update Order Totals (DOO_UPDATE_ORDER_TOTALS_PRIV)

Specifications

Use these specifications when you run the scheduled process.

Specification Description
Job Type Scheduled or as needed.
Frequency Set the frequency as needed.
Time of Day Any time.
Duration Varies depending on the parameters that you set when you run the scheduled process and how much data Order Management must process to calculate the totals.
Compatibility You can run more than one instance of this scheduled process at the same time. However, to avoid conflicts, we recommend that you run only one instance at a time.

Parameters

Use these parameters to filter the data that the scheduled process will look at.

Parameter Description

From Order Number

To Order Number

Filter the data that you want to process according to the value in the Order Number attribute on the order header.

From Ordered Date

To Ordered Date

 Filter the data that you want to process according to the value in the Ordered Date attribute on the order header.
Source System

Specify a source system. If you don't set a value, then the scheduled process will consider all source systems.

For details, see Integrate Order Management with Source Systems.
Order Status

Select a value.

  • Open. Process sales orders that are in Open status.
  • Closed. Process sales orders that are in Closed status.
  • Both. Process sales orders that are in Open status or Closed status.

If you don't set a value, then the scheduled process will consider all sales orders regardless of status.

For details, see Order Management Statuses.

All parameters are optional.

For important details, see Guidelines for Using Scheduled Processes in Order Management.