Payables and Cash Management - EBS (MOSC)

MOSC Banner

Encountered an error while running the Prepayment Status Report (XML)

edited Nov 28, 2012 8:17PM in Payables and Cash Management - EBS (MOSC) 4 commentsAnswered
Hi Guys,
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center