The sorting in AWI does not respect the NLS_SORT defined at the DB Session Logon level, so the Vara sorting does not match the PREP_PROCESS_VAR sorting.
Example: In AWI, the variable #_# Name is displayed as first entry, whereas in the PREP_PROCESS_VAR the first entry is ##_NAME
Expected behavior: When displaying a Vara, the sorting should match the same as in PREP_PROCESS_VARA which is done taking the NLS_SORT variable defined in the connection string or at the Session Level of the DB user.
Release : 21.x
Update to a fix version listed below or a newer version if available.
Component(s): Automatic.Web.Interface (AWI)
Will be fixed in Automation.Engine 21.0.9 - Planned release late December 2023
Bug ID: AE-33003
Public Description: A problem has been where variables were not sorted correctly in AWI