java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()

Oracle Community | 724373 | 5 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

    Custom reconciliation gets error

    Oracle Community | 5 years ago | 724373
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()
  2. 0

    ORA-01801: date format is too long for internal buffer

    Oracle Community | 7 years ago | 708337
    java.sql.SQLException: ORA-01801: date format is too long for internal buffer
  3. 0

    My problem in using weblogic Datasource and proxy user

    Oracle Community | 7 years ago | TakhteJamshid
    java.sql.SQLException: Unsupported feature
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Call a in out procedure using WebLogic JNDI

    Coderanch | 3 years ago | Jasi Ambalangadan
    java.sql.SQLException: Invalid column index
  6. 0

    java.sql.SQLException: ORA-00904: invalid identifier

    Google Groups | 6 years ago | laredotornado
    java.sql.SQLException: ORA-00904: "NPS_LOG"."PKG_NPSLOG"."GET_LKUP": invalid identifier

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 69 ORA-06512: at "DEV_OIM.RECON_CREATE_EVENTS", line 122 ORA-06512: at line 1 Error Code: 1422 Call: BEGIN RECON_CREATE_EVENTS.XL_SP_RECON_CREATE_EVENTS(p_intJobID=>?, p_strProfileName=>?, p_strJobName=>?, p_intBatchSize=>?, p_strEventStatus=>?, p_strChangeType=>?, p_strEntityType=>?, p_intResourceObjectKey=>?, p_strLoggedinUserName=>?, p_intMaxRetryCount=>?, p_strActionPerformed=>?, p_strKeyField=>?, p_dateActionDate=>?, p_intEventID=>?, p_intBatchID=>?, p_intPrevBatchID=>?, p_strBatchCompleteFlag=>?); END; bind => [-1, Expat User, Non-Scheduled Job, 500, Event Received, CHANGELOG, Account, 23, XELSYSADM, 5, Event Created by Recon API, 62,TESTUSER, null, => eventID, => batchID, => prevBatchID, => batch_complete_flag] Query: DataReadQuery()

      at weblogic.rjvm.ResponseImpl.unmarshalReturn()
    2. weblogic.rjvm
      ResponseImpl.unmarshalReturn
      1. weblogic.rjvm.ResponseImpl.unmarshalReturn(ResponseImpl.java:234)
      1 frame
    3. weblogic.rmi.cluster
      ClusterableRemoteRef.invoke
      1. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:348)
      2. weblogic.rmi.cluster.ClusterableRemoteRef.invoke(ClusterableRemoteRef.java:259)
      2 frames
    4. Thor.API.Operations
      tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl_1035_WLStub.createReconciliationEventx
      1. Thor.API.Operations.tcReconciliationOperationsIntfEJB_troehf_tcReconciliationOperationsIntfRemoteImpl_1035_WLStub.createReconciliationEventx(Unknown Source)
      1 frame
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    6. weblogic.ejb.container
      RemoteBusinessIntfProxy.invoke
      1. weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:85)
      1 frame
    7. Unknown
      $Proxy2.createReconciliationEventx
      1. $Proxy2.createReconciliationEventx(Unknown Source)
      1 frame
    8. Thor.API.Operations
      tcReconciliationOperationsIntfDelegate.createReconciliationEvent
      1. Thor.API.Operations.tcReconciliationOperationsIntfDelegate.createReconciliationEvent(Unknown Source)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    10. Thor.API.Base
      SecurityInvocationHandler$1.run
      1. Thor.API.Base.SecurityInvocationHandler$1.run(SecurityInvocationHandler.java:68)
      1 frame
    11. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    12. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    13. weblogic.security
      Security.runAs
      1. weblogic.security.Security.runAs(Security.java:41)
      1 frame
    14. Thor.API.Security
      weblogicLoginSession.runAs
      1. Thor.API.Security.LoginHandler.weblogicLoginSession.runAs(weblogicLoginSession.java:52)
      1 frame
    15. Thor.API.Base
      SecurityInvocationHandler.invoke
      1. Thor.API.Base.SecurityInvocationHandler.invoke(SecurityInvocationHandler.java:79)
      1 frame
    16. Unknown
      $Proxy3.createReconciliationEvent
      1. $Proxy3.createReconciliationEvent(Unknown Source)
      1 frame
    17. oracle.iam.samples
      SampleOIMClient.main
      1. oracle.iam.samples.SampleOIMClient.ReconcileExpatUser(SampleOIMClient.java:357)
      2. oracle.iam.samples.SampleOIMClient.main(SampleOIMClient.java:401)
      2 frames