Identity suggest issues with Oracle database

  • Document ID:7011127
  • Creation Date:15-Mar-2011
  • Modified Date:19-Oct-2012
    • Micro Focus Products:
      Access Governance

Resolution

One can run into stange sorting issues when using the identity select/search widgets inside the Access Governance Suite UI.

For example, if the Access Governance Suite 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