My Oracle Support Banner

Online Accounting for Receipts and Transactions fails in Database 19c with Error: An internal error has occurred in the program xla_accounting_pkg.accounting_program_document (Doc ID 2847513.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Oracle Receivables - Version 12.1.3 and later
Oracle Subledger Accounting - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Online Create Accounting is called and submit Journal Import programs as well.
The issue is noticed after the database upgraded to 19c (19.x version).
But the program fails with the following Error in the log

ERROR
-----------------------

SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-20001: -: XLA-95103: An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_create_acct_rpt_pvt.BeforeReport .  ORA-20001: -: XLA-95103: An internal error occurred.  Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_accounting_pkg.accounting_program_document.  ORA-01086: savepoint 'SP_EVENTS' never established in this session or is invalid
ORA-010
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 110
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 289
ORA-06512: at "APPS.XLA_EXCEPTIONS_PKG", line 162
ORA-06512: at "APPS.XLA_CREATE_ACCT_RPT_PVT", line 288
ORA-06512: at line 4

	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.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
	at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(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:334)
	at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
	at oracle.apps.fnd.cp.request.Run.main(Run.java:159)


Steps:
-------
1) Receivables Responsibility
NAV : Transactions --> Transactions form
Query an Invoice and run Online Accounting using Tools --> Create Accounting
It spawns Create Accounting program and Journal Import program
Create Accounting program will fail with the error in the Log file.

2) Same error is seen with Receipts as well
Receivables Responsibility
NAV : Receipts --> Receipts form
Query a Receipt and run Online Accounting using Tools --> Create Accounting
It spawns Create Accounting program and Journal Import program
Create Accounting program will fail with the error in the Log file.

Workaround 
The Create Accounting program when submit from Concurrent request, works fine.

 

Changes

 Database is upgraded to 19c

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.