Update Selected Line/Lines of Sales Order in Oracle Order Management Cloud

By Shashank Jha

In Order Management, updating selected line/lines in sales order is very essential to reduce the overall business efforts. This feature is now available in Order Management to post 18 C upgrade.

This enhancement provides significantly improved ease of use when working in the Oracle Order Management Cloud to change data on sales orders, especially those with large numbers of lines

Users can update multiple lines of a single order (a single draft order or order revision). The updates are processed immediately and can be viewed on the order page. The user can also make additional updates on the order if required and can submit the order.

Procedure to update selected lines

Sales Order: If we need to update multiple lines for the order. For example (Discount Price, Contract Date etc.)

Select the lines to be updated: Select the lines that need to be updated

Incase all the lines are to be selected click on the region in below screenshot:

To select non-adjacent Order Lines and Order line range, hold Ctrl and select the cells:

Update the selected Line:

Select the number of lines to be updated. In this case, we have selected all. Post selection, click on Update Lines as mentioned in the screenshot below:

Attributes that can be updated:

Select the attributes to be updated from the available list of attributes. The screenshots below show the list of attributes that can be updated for the selected lines.

Following are the attributes that can be updated:

  • Accounting Rule

  • Additional information

  • Allow Item Substitution

  • Bill-to-Details

  • Contract End Date

  • Contract Start Date

  • Demand Class

  • Exception Determinants

  • FOB

  • Freight Terms

  • Invoicing Rule

  • Packing Instructions

  • Payment Terms

  • Price Adjustments

  • Purchase Order

  • Purchase Order Line

  • Receivable Transaction

  • Request Type

  • Requested Date

  • Sales Credit

  • Ship-to-Details

  • Shipment Priority

  • Shipment Set

  • Shipping Instructions

  • Shipping Method

  • Supplier

  • Tax Determinants

  • Warehouse

Select the attribute to be Updated:

Select the attribute to be updated for all the selected lines. In this case we have selected the attribute “Contract Start Date” and Click on “Next” and then in next screen set a value for the attribute. Click on “Update” once the value is set up

Selected SO lines Updated:

Selected SO lines are updated for the attribute that has been changed.

Above process to be followed for updating any attribute value from the list of attributes in Update Lines. We can also update the attributes of revised lines with the same process.


About the Author

Shashank Jha is the SCM Functional Consultant with having an experience of 7+ years including Oracle ERP, SCM Cloud, and EDI. He has been part of the various implementation and support projects.


For more Information Contact Us