My Oracle Support Banner

R12:AP: Create Accounting&Accounting Program (XLAACCPB&XLAACCUP) Stuck in Running Until Shutting Down With Errors ORA-12528, ORA-03113, ORA-03114 and APP-FND-01564 (Doc ID 2832823.1)

Last updated on JANUARY 08, 2024

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:

 

 

XLAACCPB: Create Accounting


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


Program exited with status 1
APP-FND-01564: ORACLE error 3114 in get_interim_status

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





XLAACCUP: Accounting Program


[06-JAN-2022 18:03:22]: **Starts**
[07-JAN-2022 03:46:37]: **SQL error and free**
[07-JAN-2022 03:46:37]: ORACLE error 3113 in FDPSTP


Cause: FDPSTP failed due to ORA-03113: end-of-file on communication channel


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


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



Shutting down Concurrent Manager : 07-JAN-2022 03:46:37
ORA-03114: not connected to ORACLE



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'




Changes

 

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.