ORA-00001: unique constraint (IDM_OIM.PK_USR) violated at line number 1308

Issue - ORA-00001: unique constraint (IDM_OIM.PK_USR) violated at line number 1308
Problem Summary - Bulk Load Failed due to users already present with the usr_key, so find out the failed users from table
select * from USR_11G_FROM_PROD_EX1;
Update the usr_key and bulk load the failed users.
Solution - Onboard the failed users with different usr_key

Issue - BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"
Problem Summary - Bulk Load fails when used CSV File as a input in Kubernetes environment.

Solution - Oracle is having a patch on this issue
Patch 33997963: BULK LOAD UTILITY FAILS WITH "ORA-00907: MISSING RIGHT PARENTHESIS"

 

Note: Before applying any patch to your environment, please confirm it on Oracle Support.

Customize resource history page in oim accounts

Customize resource history page by adding extra number of rows to see more tasks on the page as default number of tasks to display is only 5

1) shut down OIM
2) 'cd' to $OIM_HOME/server/apps/oim.ear
3) make a backup copy of the OIGUI.war file
4) extract the js/ui/reshistroy/pages/reshist.tmpl.html and web/js/ui/reshistroy/pages/reshist.tmpl.html files from the OIGUI.war file and change the following:
data-bind="ojComponent: {component: 'ojPagingControl',data: resHistroyPagingDatasource, pageSize: 5}"></div>
to:
data-bind="ojComponent: {component: 'ojPagingControl',data: resHistroyPagingDatasource, pageSize: 15}"></div>
5) save the updated reshist.tmpl.html files back to OIGUI.war but do not update the manifest
6) start up OIM
7) log into the WLS Admin console and select "Lock and Edit" in the upper left corner
8) navigate to "Deployments" -> "Configuration" tab and select the checkbox next to "oim"
9) select "Update" at the top, use the default values and click "Finish"
10) click on "Activate Changes" in the upper left corner (I got an error but ignored it - see below that I had to restart the server)
11) click on "Control" tab at the top, scroll down to "oim", click the checkbox to the left of it then scroll back up and click "Start" -> "Servicing all requests"
NOTE: if the "oim" deployed application doesn't start properly then just shut down the OIM server and start it back up
12) go into "Resource History" and confirm if you see 5 or 15 rows now.