Hi @mmoss ,

I have check the sorting parameter in different windows (prepare wo, customer order, purchase order), except object groups (due to lack of data to sort)  in our core Envs (21R1 CORE & Aurena Apps 10),  it seems like there is a sorting issue on those windows. As you mentioned IFS doesnt recognize that 2 digits are less than 3 digits  and letters too. I think you shoud raise a support ticket to investigate the issue further. 

Cheers,

Kushan

Perhaps there is no sorting at all? In general, sorting can affect performance badly since we force Oracle the whole result set. In screens with many records, and especially for complex objects, my guess is that sorting is not done by default.

Usually this happen when the data type for the column is not a numeric one. Instead a string (varchar) type is used to store the digits as well. 

That was my first thought, but it does not look like it's the case of you look at some of the examples. The case you mention is quite common though, and is not a bug in most cases.