Change UDF size OIM 11g R2 PS3

• Login to sysadmin console. Click on the Sandbox link present at top right corner.

• It will display below page. Click on the Create Sandbox button.

• It will ask for the name and description for the sandbox. Enter the appropriate name and description.

• Click on Save and close button, it will activate the sandbox.

• Now click on User link from the left panel.

• It will open all user UDF’s, search for the desired field which is SSN No here.

• You can see maximum length is set 8 characters.  

• Change the length to desired values as per your requirement. And click on the Save and Close button.

• Close the Manage User tab. And again go to Sandbox tab by clicking earlier top sandbox link.

• Now click on export to take backup of the selected sandbox for future references.
• Publish the sandbox by clicking Publish Sandbox button. 

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