OIM 11g : SQL to List User’s Manager

User details in Oracle Identity Manager (OIM) are stored in table USR . Column USR_KEY is primary key for user, USR_LOGIN is login ID and USR_MANAGER_KEY refers to manager for that User (Note: USR_MANAGER column is not used to store manager’s detail) To list user’s manager name in OIM run below query SQL> select usr_login, […]