My Oracle Support Banner

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 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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.