oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column speci fication ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 682 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

Oracle Community | Mounika | 6 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

    GTC - FlatFile Reconciliation

    Oracle Community | 6 years ago | Mounika
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column speci fication ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 682 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  2. 0

    Error while linking the user

    Oracle Community | 5 years ago | 933033
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSERCRUD", line 3844 ORA-06512: at "TST2B_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  3. 0

    OIM - Error Reconciliation SAP

    Oracle Community | 4 years ago | Khun
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: ORA-01407: cannot update ("DEV_OIM"."OIU"."OST_KEY") to NULL ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 591 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3246 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    11g GC DBAT Trusted Source Reconciliation with custom attributes fails

    Oracle Community | 6 years ago | 836884
    oracle.iam.platform.utils.SuperRuntimeException: -9: Attribute field (HR_ROLE_CODE) does not exist in table USR.
  6. 0

    OID Trusted Recon in OIM 11g

    Oracle Community | 6 years ago | 850096
    oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: -6: Error occured in XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID 45 Target table RA_OIDUSERTRUSTED19 does not exist in OIM Database.

    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. oracle.iam.platform.utils.SuperRuntimeException

      java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column speci fication ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 682 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

      at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall()
    2. oracle.iam.reconciliation
      ActionTask.execute
      1. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1316)
      2. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkUserMatchCRUD(ReconActionDao.java:686)
      3. oracle.iam.reconciliation.impl.UserHandler.executeBulkCUD(UserHandler.java:568)
      4. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:34)
      5. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:129)
      6. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:90)
      7. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
      7 frames
    3. oracle.iam.platform
      MessageReceiver.onMessage
      1. oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
      2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
      3. oracle.iam.platform.async.messaging.MessageReceiver.onMessage(MessageReceiver.java:68)
      3 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. 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
    6. Unknown
      $Proxy329.onMessage
      1. $Proxy329.onMessage(Unknown Source)
      1 frame
    7. weblogic.ejb.container
      MDListener.onMessage
      1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
      2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
      3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
      3 frames
    8. 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
    9. weblogic.work
      ExecuteThread.run
      1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:528)
      2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
      3. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
      3 frames