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

Oracle Community | 2752381 | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    DBAT Trusted Reconciliation error

    Oracle Community | 2 years ago | 2752381
    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
  2. 0

    OIM11gr2 Error while performing Recon with status field

    Oracle Community | 4 years ago | 967886
    oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-19202: Error occurred in XML processing ORA-00972: identifier is too long ORA-06512: at "SYS.DBMS_XMLGEN", line 7 ORA-06512: at "SYS.DBMS_XMLGEN", line 147 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 294 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3380 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  3. 0

    Problem during Active Directory riconciliation event oracle identity manager 11gr2

    Oracle Community | 2 years ago | 2781494
    java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 4 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 4 ORA-01747: invalid user.table.column, table.column, or column specification ORA-06512: at "DEV_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Trusted Source Errore 11g - OIM_SP_RECONBLKUSRMLSWRAPPER

    Oracle Community | 5 years ago | 935811
    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
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    8. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    11. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
    12. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
    13 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ReconActionDao$1ReconDBCall$1.process
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1465)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall$1.process(ReconActionDao.java:1448)
    2 frames
  5. oracle.iam.platform
    OIMTransactionCallback.doInTransaction
    1. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
    2. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
    2 frames
  6. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
    1 frame
  7. oracle.iam.platform
    OIMTransactionManager.execute
    1. oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
    1 frame
  8. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1448)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1444)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1492)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:750)
    6. oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:403)
    7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:56)
    8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:118)
    9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:91)
    10. oracle.iam.reconciliation.impl.ActionTask.executeTask(ActionTask.java:77)
    11. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:66)
    11 frames
  9. oracle.iam.platform
    MessageReceiver.onMessage
    1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:99)
    2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:69)
    3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
    3 frames
  10. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  11. com.bea.core
    JdkDynamicAopProxy.invoke
    1. com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
    2. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    4. com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
    5. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    6. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)
    7. com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)
    8. com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    9. com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    9 frames
  12. com.sun.proxy
    $Proxy566.onMessage
    1. com.sun.proxy.$Proxy566.onMessage(Unknown Source)
    1 frame
  13. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:583)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:486)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:388)
    3 frames
  14. weblogic.jms.client
    JMSSession$UseForRunnable.run
    1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4659)
    2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4345)
    3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3821)
    4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:115)
    5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5170)
    5 frames
  15. weblogic.work
    ExecuteThread.run
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    3. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
    3 frames