oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00936: missing e xpression ORA-06512: at "PROD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1072 ORA-06512: at "PROD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

Oracle Community | Giuseppe | 4 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

    SSH Reconciliation Issue after applying BP4 for OIM11g

    Oracle Community | 4 years ago | Giuseppe
    oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00936: missing e xpression ORA-06512: at "PROD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1072 ORA-06512: at "PROD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  2. 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)
  3. 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.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 0

    OIM11g - GTC Trusted - Events are in Data Received state

    Oracle Community | 6 years ago | vicky
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 11330 ORA-01013: user requested cancel of current operation ORA-06512: at "QIOR_OIM.XL_SP_RECONBLKUSRRQDCVALDNMTCH", line 760 ORA-06512: at "QIOR_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 54 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

    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

      oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00936: missing e xpression ORA-06512: at "PROD_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 1072 ORA-06512: at "PROD_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 90 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:1344)
      2. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:844)
      3. oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:72)
      4. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
      5. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:137)
      6. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
      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:101)
      2. oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:71)
      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
      $Proxy348.onMessage
      1. $Proxy348.onMessage(Unknown Source)
      1 frame
    7. weblogic.ejb.container
      MDListener.onMessage
      1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
      2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
      3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
      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:209)
      3. weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
      3 frames