oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

Oracle Community | 2661067 | 3 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

    I am getting an error while migrating AD User data from OIM 9i to 11gR2

    Oracle Community | 3 years ago | 2661067
    oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

    Root Cause Analysis

    1. oracle.iam.platform.tx.OIMTransactionException

      java.sql.SQLException: ORA-20001: An error was encountered - XL_SP_ReconBlkRqdcAcntMatch while Processing Batch no 45503 ORA-20001: An error was encountered - XL_SP_ReconBlkUserMatch while Processing Batch ID 45503 ORA-01013: user requested cancel of current operation ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKRQDCACNTMATCH", line 468 ORA-06512: at "OIM01PT_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 69 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

      at oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command()
    2. oracle.iam.reconciliation
      ActionTask.execute
      1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1440)
      2. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1436)
      3. oracle.iam.reconciliation.dao.DBCall.execute(DBCall.java:17)
      4. oracle.iam.reconciliation.dao.ReconActionDao.processSPCall(ReconActionDao.java:1484)
      5. oracle.iam.reconciliation.dao.ReconActionDao.executeBulkAccountMatchCRUD(ReconActionDao.java:905)
      6. oracle.iam.reconciliation.impl.AccountHandler.executeBulkCUD(AccountHandler.java:77)
      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.execute(ActionTask.java:72)
      10 frames
    3. 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
    4. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor1309.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:601)
      3 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
      $Proxy459.onMessage
      1. $Proxy459.onMessage(Unknown Source)
      1 frame
    7. 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
    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:545)
      2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
      3. weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      3 frames