Encountered an error while running the Prepayment Status Report (XML)
Hi Guys,
We encountered an error while running the Prepayment Status Report (XML) in Payables. Below is the log of the report:
We encountered an error while running the Prepayment Status Report (XML) in Payables. Below is the log of the report:
+---------------------------------------------------------------------------+
Payables: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
APXINPSR_XML module: Prepayments Status Report (XML)
+---------------------------------------------------------------------------+
Current system time is 20-NOV-2012 10:49:01
+---------------------------------------------------------------------------+
XDO Data Engine Version No: 5.6.3
Resp: 50789
Org ID : 328
Request ID: 5530054
All Parameters: P_INCLUDE_INVOICE=Y:P_INCLUDE_CREDIT=Y:P_VENDOR_TYPE_LOOKUP_CODE=EMPLOYEE:P_VENDOR_ID=4622:P_FROM_DATE=:P_TO_DATE=:P_PREPAYMENT_TYPE=TEMPORARY:P_PREPAYMENT_LINE_FLAG=N:P_DEBUG_SWITCH=N:P_TRACE_SWITCH=N:DebugFlag=N
Data Template Code: APXINPSR_XML
Data Template Application Short Name: SQLAP
Debug Flag: N
{P_PREPAYMENT_LINE_FLAG=N, P_VENDOR_TYPE_LOOKUP_CODE=EMPLOYEE, P_VENDOR_ID=4622, P_TRACE_SWITCH=N, P_TO_DATE=, P_DEBUG_SWITCH=N, P_INCLUDE_CREDIT=Y, P_FROM_DATE=, P_PREPAYMENT_TYPE=TEMPORARY, P_INCLUDE_INVOICE=Y}
Calling XDO Data Engine...
[112012_104904785][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-20101:
ORA-06512: at "APPS.AP_APXINPSR_XMLP_PKG", line 262
ORA-06512: at line 4
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
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.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1225)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3857)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:650)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
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
Tagged:
0