One can run into strange sorting issues when using the identity select/search widgets inside the IdentityIQ UI. For example, if the IdentityIQ data is in German, the default Oracle sort order of binary can abort the search and return no values.
Set the following Oracle sorting variables to the following:
NLS_COMP=LINGUISTIC
NLS_SORT=BINARY_CI
Note: The information above applies only to Oracle 11.2.0.2 prior to Patch 25. If you are using Oracle 11.2.02 Patch 25 or later or Oracle 11.2.0.3, this workaround is not required.
