During bulk load utility we may get lots of isssues but we don't get the exact reason and also don't know where to find out as log files. In this blog I will give you one query which will help you in bulk load utility troubleshooting.

Go to the SQL Developer and connect as the OIM schema user.

Run the following query:

"SELECT MSG FROM OIM_BLKLD_LOG WHERE MODULE = 'USER' AND LOG_LEVEL = 'ERROR' ORDER BY MSG_SEQ_NO;"

Replace USER with "ACCOUNT" or "ROLE" depend on what you are loading in to the OIM.

This will give you the exact error which you can't see in the logs.

Animesh Anand

Add comment