My Oracle Support Banner

GLLEZL: Journal Import Errors with " AFPRSR-Resubmit_Time failed due to ORA-03114: not connected to ORACLE", " Program was terminated by signal 6" (Doc ID 2646370.1)

Last updated on MARCH 12, 2020

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.


On : R12 version, Journal Import

When attempting to import the journals from subledger , following error occurs 

sError in: gllcbh
Function return status: 0
Function Err Message: Executing bch_prep
Function warning number: -1
sqlcaid: sqlabc: 0 sqlcode: -3113 sqlerrml: 48
ORA-03113: end-of-file on communication channel

sqlerrp: sqlerrd: 0 0 0 12 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: Process logging off database and exiting ...
Start of log messages from FND_FILE
End of log messages from FND_FILE
ORACLE error 3114 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to OR A-03114: not connected to ORACLE
Program was terminated by signal 6

The issue can be reproduced at will with the following steps:
1. Log into Subledger 
2. Submit Create Accounting in Final 


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

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