OIM schema user password expire

• Problem: - OIM schema user password expires.
• Solution:-
• Check the status of accounts expiration of all schema users by executing following command

select USERNAME, EXPIRY_DATE, LOCK_DATE, ACCOUNT_STATUS from dba_users where    USERNAME like '%<SCHEMA_PREFIX>%';

• It will display the account summary information for all schema users.

• Now change the password those users whose passwords have been expired by executing following command.

         alter user USERNAME identified by <Password>;