In Oracle Identity Governance (OIG) 184.108.40.206 During User Creation When Searching Organizations, The Result Is Empty with Error: "The sql command not properly ended".
(Doc ID 2906747.1)
Last updated on NOVEMBER 02, 2022
Applies to:Identity Manager - Version 220.127.116.11.220703 and later
Information in this document applies to any platform.
During user creation in OIG, when we search for an organization, the results are empty and the log shows: "ORA-00933: The sql command not properly ended".
OIM environment has over 8K Organizations.
Steps to replicate:
- Create an admin user with admin roles User Admin and Organization Admin assigned.
- Login into /identity console, click on Create User
- Search for an organization to provide that information for the user.
- No results are seen.
The issue does not occur for default OIM System Administrator user.
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