oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored

tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • DBAT Trusted Reconciliation error
    via by 2752381,
  • Oracle EBS Report creation
    via by Sardar Nale,
  • Debug « Middleware Magic
    via by Unknown author,
  • Debug « WebLogic
    via by Unknown author,
  • JDBC « WebLogic
    via by Unknown author,
  • Closed Connection Error on weblogic connection pool
    via by Suneesh Raman-Oracle,
    • oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1448) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1444) at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17) at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1492) at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:750) at oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:403) at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:56) at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:118) at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:91) at oracle.iam.reconciliation.impl.ActionTask.executeTask(ActionTask.java:77) at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:66) at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99) at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69) at oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy566.onMessage(Unknown Source) at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583) at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486) at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659) at weblogic.jms.client.JMSSession.execute(JMSSession.java:4345) at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821) at weblogic.jms.client.JMSSession.access$000(JMSSession.java:115) at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170) at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256) at weblogic.work.ExecuteThread.run(ExecuteThread.java:221) Caused by: java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00905: object DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER is invalid ORA-06550: line 1, column 7: PL/SQL: Statement ignored at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539) at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1465) at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1448) at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13) at oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22) ... 39 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    balintn
    balintn11 times, last one,
    Cafecanudo
    Cafecanudo2 times, last one,
    52 more bugmates