java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows

Oracle Community | TrsenZhang | 5 months ago
  1. 0

    EM 13C occur ORA-01422: exact fetch returns more than requested number of rows when add database for target machine

    Oracle Community | 5 months ago | TrsenZhang
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
  2. 0

    sdo_filter error while trying to do results paging

    Oracle Community | 7 years ago | user10750794
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "MDSYS.SDO_3GL", line 1320
  3. 0

    iExpense - Error Searching for Expense Report

    Oracle Community | 3 years ago | LMartin
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 351
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    R12: Payment error "Payment Instruction Format " ends in error

    Oracle Community | 5 years ago | VikramAwotar
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at ""APPS.IBY_EXTRACTGEN_PVT"", line 353 ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  6. 0

    Format Payment Instructions with Text Output fails with ora 01422

    Oracle Community | 5 years ago | Tam_11
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)

    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

      at oracle.sysman.emdrep.target.EntityUtil.handleAddNYMException()
    2. oracle.sysman.emdrep
      EntityUtil.createEntities
      1. oracle.sysman.emdrep.target.EntityUtil.handleAddNYMException(EntityUtil.java:2551)
      2. oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2389)
      3. oracle.sysman.emdrep.target.EntityUtil.createNYMEntities(EntityUtil.java:2275)
      4. oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3590)
      5. oracle.sysman.emdrep.target.EntityUtil.createEntities(EntityUtil.java:3560)
      5 frames
    3. oracle.sysman.emSDK
      EntityManager.createEntities
      1. oracle.sysman.emSDK.core.target.EntityManager.createEntities(EntityManager.java:320)
      1 frame
    4. oracle.sysman.db
      DbGuidedDiscoveryTrainBean.doSave
      1. oracle.sysman.db.discovery.target.manager.TargetSaveManager.saveCurrentDatabase(TargetSaveManager.java:289)
      2. oracle.sysman.db.discovery.target.manager.TargetSaveManager.doSave(TargetSaveManager.java:118)
      3. oracle.sysman.db.discovery.ui.trainbean.guideddiscovery.DbGuidedDiscoveryTrainBean.doSave(DbGuidedDiscoveryTrainBean.java:138)
      3 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    6. EL
      MethodExpressionImpl.invoke
      1. com.sun.el.parser.AstValue.invoke(AstValue.java:254)
      2. com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
      2 frames
    7. oracle.sysman.emSDK
      AdfUtil.invokeEL
      1. oracle.sysman.emSDK.view.util.AdfUtil.invokeEL(AdfUtil.java:641)
      1 frame
    8. oracle.sysman.sdkImpl
      ProgressBackingBean.pollListener
      1. oracle.sysman.sdkImpl.core.uifwk.ui.progress.ProgressBackingBean.pollListener(ProgressBackingBean.java:221)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    10. EL
      MethodExpressionImpl.invoke
      1. com.sun.el.parser.AstValue.invoke(AstValue.java:254)
      2. com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
      2 frames
    11. Apache MyFaces Trinidad API
      WrapperEvent.broadcastWrappedEvent
      1. org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodExpression(UIXComponentBase.java:2016)
      2. org.apache.myfaces.trinidad.component.UIXPoll.broadcast(UIXPoll.java:98)
      3. org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)
      4. org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)
      4 frames
    12. oracle.adf.view
      UIXInclude.broadcast
      1. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:111)
      1 frame
    13. Apache MyFaces Trinidad API
      WrapperEvent.broadcastWrappedEvent
      1. org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:364)
      2. org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:82)
      2 frames
    14. oracle.adf.view
      UIXInclude.broadcast
      1. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:168)
      2. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:510)
      3. oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:171)
      4. oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:115)
      4 frames
    15. JavaEE 7
      UIViewRoot.processApplication
      1. javax.faces.component.UIViewRoot.broadcastEvents(Unknown Source)
      2. javax.faces.component.UIViewRoot.processApplication(Unknown Source)
      2 frames
    16. oracle.adfinternal.view
      LifecycleImpl.execute
      1. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)
      2. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)
      3. oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)
      3 frames
    17. JavaEE 7
      FacesServlet.service
      1. javax.faces.webapp.FacesServlet.service(Unknown Source)
      1 frame
    18. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
      2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
      3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
      5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
      6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      6 frames
    19. oracle.adf.model
      ADFBindingFilter.doFilter
      1. oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)
      1 frame
    20. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    21. oracle.adf.view
      WebCenterComposerFilter.doFilter
      1. oracle.adf.view.page.editor.webapp.WebCenterComposerFilter.doFilter(WebCenterComposerFilter.java:117)
      1 frame
    22. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    23. oracle.adf.share
      ServletADFFilter.doFilter
      1. oracle.adf.share.http.ServletADFFilter.doFilter(ServletADFFilter.java:77)
      1 frame
    24. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    25. oracle.adfinternal.view
      RegistrationFilter.doFilter
      1. oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)
      1 frame
    26. org.apache.myfaces
      TrinidadFilterImpl$FilterListChain.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)
      1 frame
    27. oracle.adfinternal.view
      AdsFilter.doFilter
      1. oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)
      1 frame
    28. org.apache.myfaces
      TrinidadFilterImpl.doFilter
      1. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)
      2. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)
      3. org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)
      3 frames
    29. Apache MyFaces Trinidad API
      TrinidadFilter.doFilter
      1. org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
      1 frame
    30. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    31. oracle.sysman.eml
      EMRepLoginFilter.doFilter
      1. oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:800)
      1 frame
    32. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    33. oracle.sysman.eml
      MBeanServerConnFilter.doFilter
      1. oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43)
      1 frame
    34. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    35. oracle.adf.library
      LibraryFilter.doFilter
      1. oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:202)
      1 frame
    36. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    37. oracle.sysman.emInternalSDK
      EntityManagerFilter.doFilter
      1. oracle.sysman.emInternalSDK.core.model.utils.EntityManagerFilter.doFilter(EntityManagerFilter.java:46)
      1 frame
    38. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    39. oracle.sysman.eml
      ContextInitFilter.doFilter
      1. oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:561)
      1 frame
    40. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    41. oracle.adfinternal.view
      AdfFacesCachingFilterImpl.doFilter
      1. oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilterImpl.doFilter(AdfFacesCachingFilterImpl.java:136)
      1 frame
    42. oracle.adf.view
      AdfFacesCachingFilter.doFilter
      1. oracle.adf.view.rich.webapp.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:66)
      1 frame
    43. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    44. oracle.sysman.core
      EMRuntimeExceptionFilter.doFilter
      1. oracle.sysman.core.app.exception.EMRuntimeExceptionFilter.doFilter(EMRuntimeExceptionFilter.java:150)
      1 frame
    45. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    46. oracle.security.jps
      JpsAbsFilter$1.run
      1. oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)
      1 frame
    47. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    48. oracle.security.jps
      JpsFilter.doFilter
      1. oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
      2. oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
      3. oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)
      4. oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)
      5. oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)
      5 frames
    49. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    50. oracle.dms.servlet
      DMSServletFilter.doFilter
      1. oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)
      1 frame
    51. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      2. weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
      3. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      4. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
      5. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
      5 frames
    52. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    53. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    54. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame
    55. Atmosphere weblogic
      ServletRequestImpl.run
      1. weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)
      2. weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)
      3. weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
      4. weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1575)
      4 frames
    56. weblogic.servlet.provider
      ContainerSupportProviderImpl$WlsRequestExecutor.run
      1. weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
      1 frame
    57. weblogic.work
      ExecuteThread.run
      1. weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
      2. weblogic.work.ExecuteThread.run(ExecuteThread.java:263)
      2 frames