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)


Solutions on the web

Solution icon of oraclecommunity
via Oracle Community by 877241, 1 year ago
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)

Solution icon of oraclecommunity
via Oracle Community by ejani, 1 year ago
-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)

Solution icon of oraclecommunity
via Oracle Community by Khun, 1 year ago
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)

Solution icon of oraclecommunity
via Oracle Community by 967886, 1 year ago
"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)

Solution icon of oraclecommunity
via Oracle Community by user651347, 1 year ago
java.sql.SQLSyntaxErrorException: ORA-00957: duplicate column name ORA-06512: at "IDMTST_OIM.OIM_SP_RECONBLKUSERCRUD", line 728 ORA-06512: at "IDMTST_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

Solution icon of oraclecommunity
via Oracle Community by Giuseppe, 1 year ago
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)

Solution icon of oraclecommunity
via Oracle Community by Mounika, 1 year ago
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)

Solution icon of oraclecommunity
via Oracle Community by 933033, 1 year ago
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)

Solution icon of oraclecommunity
via Oracle Community by S.K.N, 1 year ago
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSERCRUD", line 3925 ORA-06512: at "DEV_OIM.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

Solution icon of oraclecommunity
via Oracle Community by 788860, 1 year ago
java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (OIM11GDB.FK_RECON_EVENTS_USR) violated - parent key not found ORA-06512: at "OIM11GDB.OIM_SP_RECONBLKUSERCRUD", line 759 ORA-06512: at "OIM11GDB.OIM_SP_RECONBLKUSRMLSWRAPPER", line 71 ORA-06512: at line 1at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:24)

Stack trace

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)
	at oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1330)
	at oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:830)
	at oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:72)
	at oracle.iam.reconciliation.impl.BaseEntityTypeHandler.process(BaseEntityTypeHandler.java:42)
	at oracle.iam.reconciliation.impl.ActionEngine.processBatch(ActionEngine.java:137)
	at oracle.iam.reconciliation.impl.ActionEngine.execute(ActionEngine.java:92)
	at oracle.iam.reconciliation.impl.ActionTask.execute(ActionTask.java:72)
	at oracle.iam.platform.async.impl.TaskExecutor.executeUnmanagedTask(TaskExecutor.java:100)
	at oracle.iam.platform.async.impl.TaskExecutor.execute(TaskExecutor.java:70)
	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:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	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 $Proxy389.onMessage(Unknown Source)
	at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:574)
	at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:477)
	at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:379)
	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:528)
	at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
	at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: 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(T4CTTIoer.java:405)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1075)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9259)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
	at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
	at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1302)
	at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1285)
	at oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
	... 35 more

Write tip

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

Users with the same issue

2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
70 more bugmates