oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 730 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)

Oracle Community | 881156 | 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

    OIM 11g R2 - Recon events not getting linked

    Oracle Community | 4 years ago | 881156
    oracle.iam.platform.tx.OIMTransactionException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 730 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 ORA-06512: at line 1at oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:28)
  2. 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-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.XL_SP_RECONBLKCHILDMTHACNTCRUD", line 730 ORA-06512: at "DEV_OIM.XL_SP_RECONBLKACNTRQDCMTCHCRUD", line 91 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
      ReconActionDao$1ReconDBCall.command
      1. oracle.iam.reconciliation.dao.ReconActionDao$1ReconDBCall.command(ReconActionDao.java:1423)
      1 frame