java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XM LPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataS ource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPG EN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStruc ture(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XML PGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLP GEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGE N.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDa taStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processDa ta(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(D ataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram (JCP4XDODataEngine.java:294)

Oracle Community | User319671 | 4 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

    Issue with Concurrent Program log file output.

    Oracle Community | 4 years ago | User319671
    java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XM LPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataS ource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPG EN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStruc ture(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XML PGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLP GEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGE N.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDa taStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processDa ta(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(D ataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram (JCP4XDODataEngine.java:294)

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00932: inconsistent datatypes: expected DATE got NUMBER at oracle.jdbc.driver.SQLStateMapping.newSQLException (SQLStateMapping.java:91) at oracle.jdbc.driver.DatabaseError.newSQLException(D atabaseError.java:133) at oracle.jdbc.driver.DatabaseError.throwSqlException (DatabaseError.java:206) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:455) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoe r.java:413) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java: 1034) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4 CPreparedStatement.java:194) at oracle.jdbc.driver.T4CPreparedStatement.executeFor Describe(T4CPreparedStatement.java:791) at oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:866) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1189) at oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3387) at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3431) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1 491) at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XM LPGEN.java:1947) at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataS ource(XMLPGEN.java:501) at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPG EN.java:445) at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStruc ture(XMLPGEN.java:308) at oracle.apps.xdo.dataengine.XMLPGEN.processData(XML PGEN.java:273) at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLP GEN.java:215) at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGE N.java:254) at oracle.apps.xdo.dataengine.DataProcessor.processDa taStructre(DataProcessor.java:390) at oracle.apps.xdo.dataengine.DataProcessor.processDa ta(DataProcessor.java:355) at oracle.apps.xdo.oa.util.DataTemplate.processData(D ataTemplate.java:334) at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram (JCP4XDODataEngine.java:294)

      at oracle.apps.fnd.cp.request.Run.main()
    2. oracle.apps.fnd
      Run.main
      1. oracle.apps.fnd.cp.request.Run.main(Run.java:157)
      1 frame