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