java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

Oracle Community | 1027890 | 1 year ago
  1. 0

    Custom Account Analysis Program ending in error

    Oracle Community | 1 year ago | 1027890
    java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
  2. 0

    Reg: Error in Data Template ( java.sql.SQLException: ORA-00900: invalid SQL

    Oracle Community | 6 years ago | 699730
    java.sql.SQLException: ORA-00900: invalid SQL statement
  3. 0

    Manipulate Report Language?

    Oracle Community | 1 decade ago | alexander.steinbeisz
    java.sql.SQLException: ORA-01722: num?r nevalid
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem in Data Template ORA-00911: invalid character

    Oracle Community | 7 years ago | 665465
    java.sql.SQLException: ORA-00920: invalid relational operator
  6. 0

    Reg: Error in Data Template ( java.sql.SQLException: ORA-00900: invalid SQL - webnetta.com

    webnetta.com | 4 months ago
    java.sql.SQLException: ORA-00900: invalid SQL statement

    12 unregistered visitors
    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-01427: single-row subquery returns more than one row

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
      11 frames
    3. oracle.apps.xdo
      JCP4XDODataEngine.runProgram
      1. oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
      2. oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
      3. oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
      4. oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
      5. oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
      6. oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
      7. oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
      8. oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
      9. oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
      10. oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:348)
      11. oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:293)
      11 frames
    4. oracle.apps.fnd
      Run.main
      1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
      1 frame