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
  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)
  3. 0

    OIMClient: Failed to create the request in the repository

    Oracle Community | 3 years ago | Zhang Zhongyi
    oracle.iam.platform.tx.OIMTransactionException: oracle.iam.request.exception.RequestServiceException: Failed to create the request in the repository.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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