Opening Certification in Oracle Identity Manager (OIM) Migrated From Oracle Identity Analytics (OIA) Throws Error: SQL [SELECT USR_KEY,USR_LOGIN FROM USR WHERE USR_KEY IN ( ? )]; ORA-01722: invalid number
(Doc ID 2497571.1)
Last updated on DECEMBER 06, 2021
Applies to:Identity Manager - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
You have migrated certifications from OIA to OIM. and when opening some of the migrated certifications you get the following error in the UI:
With the following stacktrace in the logs:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!