oracle.iam.platform.utils.SuperRuntimeException: oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 223 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3161 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 89 ORA-06512: at line 1at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:146)

Oracle Community | 877241 | 5 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

    Target Recon Not Working

    Oracle Community | 5 years ago | 877241
    oracle.iam.platform.utils.SuperRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 223 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3161 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 89 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)
  2. 0

    Using Non-APPS schema with Oracle Apps Adapter

    Oracle Community | 5 years ago | 818739
    java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5682 ORA-06512: at "SYS.DBMS_AQADM", line 314 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  3. 0

    Error after applying the patch p12748351

    Oracle Community | 5 years ago | LeylaDah
    java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis ORA-06512: at "PROD_OIM.XL_SP_RECON_ACCOUNT_DATA_MATCH", line 149 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid datatype while calling a procedure from java

    Stack Overflow | 3 years ago | user980956
    java.sql.SQLSyntaxErrorException: ORA-00902: invalid datatype</p> <pre><code>at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  6. 0

    Unable to Start Oracle WebCenter Spaces

    Oracle Community | 7 years ago | user12303639
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
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.SQLSyntaxErrorException

    ORA-00920: invalid relational operator ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKACCOUNTCHGLOG", line 223 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 3161 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 89 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    2. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
    3. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
    4. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
    5. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
    1 frame
  4. oracle.iam.reconciliation
    ActionTask.execute
    1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1302)
    2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1285)
    3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
    4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1330)
    5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:830)
    6. oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:72)
    7. oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
    8. oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:137)
    9. oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
    10. oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
    10 frames
  5. 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
  6. 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
  7. 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
  8. Unknown
    $Proxy389.onMessage
    1. $Proxy389.onMessage(Unknown Source)
    1 frame
  9. 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
  10. 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
  11. 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