My Oracle Support Banner

R12: AP: The Concurrent Program "Create Accounting" (XLAACCPB) and Child "Accounting Program" (XLAACCUP) Stuck in Running Phase for Long Time Until are Shutting Down with Error Messages "APP-FND-01564" and "ORA-03114: not connected to ORACLE" (Doc ID 2832823.1)

Last updated on FEBRUARY 08, 2022

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The concurrent program "Create Accounting" (short name XLAACCPB) and child concurrent program "Accounting Program" (short name XLAACCUP) are stuck in "Running" Phase for long time until are shutting down with the following error messages retrieved in the logs:

 

 

Current system time is 06-JAN-2022 18:03:15

Calling XDO Data Engine...
[010722_034637360][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1205)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)
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)

Exception in thread "main" oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.


Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections


Cause: get_interim_status failed due to ORA-03114: not connected to ORACLE.

The SQL statement being executed at the time of the error was: &SQLSTMT and was executed from the file &ERRFILE.
ORACLE error 3114 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE

Shutting down Concurrent Manager : 07-JAN-2022 03:46:37



The Online Create Accounting from Invoice Workbench/Payment Workbench for a specific invoice/payment is working fine.

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Log in the Payables responsibility
  2. Click on - View - Requests - Submit a New Request - Single Request - OK
  3. Name: Create Accounting
  4. Fill the desired parameters - OK
  5. Submit
  6. Wait until it is finished
  7. Review the log of the concurrent program 'Create Accounting'




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!


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