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
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded 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)

    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