My Oracle Support Banner

How to Sort by Delivery Number in Shipping Transactions Form When Querying by Order Number (Doc ID 1999803.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Shipping Execution - Version and later
Information in this document applies to any platform.


Would like to know how to sort the Delivery number in ascending order in the Shipping Transactions Form.

The needs of the users are to query for a specific order in the Shipping Transactions Form.
If that order has multiple deliveries, they want them to display in ascending order. Example: 28108, 28109, 28110 etc...

Example is for sales order 67371:
This order has six different deliveries:  4306393, 4306394, 4306395, 4306396, 4306397, 4306398 
When viewing the list of deliveries in the Shipping Transactions Form, the delivery numbers are not displayed in ascending order.
They display as follows:  4306394, 4306393, 4306395, 4306397, 4306398, 4306396

Users are expecting this form to display the list of deliveries in ascending order.

Is there a forms personalization to display the delivery numbers in ascending order when querying for a specific sales order?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.