+---------------------------------------------------------------------------+
Order Management: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
XXONT_OM_SOACK_CLD_RPT: EMR OM Sales Order Acknowledgement Report COLDCHAIN
+---------------------------------------------------------------------------+
Current system time is 14-MAY-2025 16:21:38
+---------------------------------------------------------------------------+
CP main executing runProgram for oracle.apps.xdo.oa.cp.JCP4XDODataEngine
XDO Data Engine Version No: 10.1.3.4.2
Resp: 65648
Org ID : 2936
Request ID: 401929796
All Parameters:
i_Order_Number_From=30004914:i_Order_Number_To=30004914:i_Order_Date_From=:i_Order_
Date_To=:i_Customer_Number=:i_Customer_PO_Num=
Data Template Code: XXONT_OM_SOACK_CLD_RPT
Data Template Application Short Name: ONT
Debug Flag: N
{i_Order_Date_To=, i_Customer_Number=, i_Order_Date_From=, i_Customer_PO_Num=,
i_Order_Number_From=30004914, i_Order_Number_To=30004914}
Calling XDO Data Engine...
[051425_162141381][][EXCEPTION] [DEBUG] Trying to get XDO_TOP in CP parameter
list : null
[051425_162141383][][EXCEPTION] [DEBUG] Trying to get XDO_TOP in Apps Preference :
null
[051425_162141384][][EXCEPTION] [DEBUG] Trying to get XDO_TOP in Apps Profile :
null
[051425_162141384][][EXCEPTION] [DEBUG] Trying to get XDO_TOP in Apps Env :
/floraa1ap/12.2/fs2/EBSapps/appl/xdo/12.0.0
[051425_162141384][][EXCEPTION] [DEBUG] Setting XDO_TOP to java system properties :
/floraa1ap/12.2/fs2/EBSapps/appl/xdo/12.0.0
XDO Config properteies :null
--SQLException
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.jav
a:947)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.
java:3769)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.jav
a:3823)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatem
entWrapper.java:1671)
at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(Unknown Source)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(Unknown Source)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(Unknown
Source)
at oracle.apps.xdo.dataengine.DataProcessor.processData(Unknown Source)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:350)
at
oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:311)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
CP main completed runProgram for oracle.apps.xdo.oa.cp.JCP4XDODataEngine
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Entering INTO BEFORE REPORT - 2936
Entering INTO BEFORE REPORT LOOP- 2936-12620001
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
337
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 14-MAY-2025 16:21:41
+---------------------------------------------------------------------------+
