Monday, December 12, 2016

java.sql.SQLDataException: ORA-01861: literal

Oracle Concurrent programs are getting below error.

Debug Flag: N
{P_END_DATE=2016/12/02 00:00:00, P_START_DATE=2016/11/01 00:00:00, P_TYPE=AMEX}
Calling XDO Data Engine...
--SQLException
java.sql.SQLDataException: ORA-01861: literal does not match format string
 
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
        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) 

There are below things that you can check to troubleshoot.

1. Check the template file if any date field is creating any issue.
2. Any data it is pulling are triggering this issue.
 

No comments:

Post a Comment

Troubleshooting ACFS-07981: Metadata Validation Errors

  Troubleshooting ACFS-07981: Metadata Validation Errors Introduction The ACFS-07981 error indicates that an attempt to run an online file ...