Tuesday, December 13, 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

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...