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