0 Replies Latest reply: Oct 18, 2013 5:55 AM by user13100220 RSS

    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

    user13100220

      Hi,

      I got this error ..i am not figured out where the error lies .please resolve will be great appriciation ....

       

      XDO Data Engine Version No: 5.6.3

      Resp: 50697

      Org ID : null

      Request ID: 1425152

      All Parameters: P_ORG_ID=111:P_FROM_DATE="2013/01/01 00:00:00":P_TO_DATE="2013/08/31 00:00:00":P_VENDOR_NAME=1235

      Data Template Code: TECREMDET

      Data Template Application Short Name: SQLAP

      Debug Flag: N

      {P_VENDOR_NAME=1041, P_TO_DATE=2013/08/31 00:00:00, P_FROM_DATE=2013/01/01 00:00:00, P_ORG_ID=101}

      Calling XDO Data Engine...

      --SQLException

      java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

       

      at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)

      at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)

      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)

      at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)

      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1189)

      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)

      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)

      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)

      at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)

      at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)

      at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)

      at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)

      at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)

      at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)

      at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)

      at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)

      at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)

      at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)

      at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)

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

       

      +---------------------------------------------------------------------------+

      Start of log messages from FND_FILE

      +---------------------------------------------------------------------------+

      +---------------------------------------------------------------------------+

      End of log messages from FND_FILE

      +---------------------------------------------------------------------------+

       

       

      +---------------------------------------------------------------------------+

      Executing request completion options...

       

      +------------- 1) PUBLISH -------------+

      Beginning post-processing of request 1425152 on node ORAPPSUS64 at 18-OCT-2013 16:43:39.

      Post-processing of request 1425152 failed at 18-OCT-2013 16:43:40 with the error message:

      One or more post-processing actions failed. Consult the OPP service log for details.

      +--------------------------------------+

       

       

      Finished executing request completion options.

       

      +---------------------------------------------------------------------------+

      Concurrent request completed

      Current system time is 18-OCT-2013 16:43:40

       

      +---------------------------------------------------------------------------+

       

      Thanks,

       

      user.