SOA: JBO-29000: Unexpected exception caught: oracle.bpel.services.workflow.client.WorkflowServiceClientException, msg=javax.naming.NameNotFoundException: Unable to resolve 'TaskQueryService'.

Check soa-infra.war's status from admin console. Restart the same.

ORA-03115: unsupported network datatype or representation

So, I created a connection with weblogic data source and tried to execute a query and got the following error:
ORA-03115: unsupported network datatype or representation[[
 java.sql.SQLException: ORA-03115: unsupported network datatype or representation

The solution is simple,
Instead of
                  resultSet = preparedStatement.executeQuery(myQuery);
use
                   resultSet = preparedStatement.executeQuery();

OIM: unable to find LoginModule class: weblogic.security.auth.login.UsernamePasswordLoginModule, when connecting from IDE

Solution: Add wlfullclient.jar in your class path,

The steps to create wlfullclient.jar can be found at: http://iamsecurity-tips.blogspot.com/search/label/wlfullclient.jar

OIM: User unlock query

The following query can be executed to unlock an OIM user:

UPDATE USR SET USR_LOCKED=0,USR_LOGIN_ATTEMPTS_CTR=0, USR_LOCKED_ON = null,USR_MANUALLY_LOCKED = null  WHERE USR_LOGIN='<PROVIDE_USER_LOGIN>';