My Oracle Support Banner

EGL9.2: Online Journal Post Abends At Step FTDOCAE_LIBR.GenDocSq.Step08 When Multiple Reversal Journals Imported via Spreadsheet Are Posted at Same Time. (Doc ID 1992534.1)

Last updated on AUGUST 20, 2019

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.



When multiple users attempt to concurrently post reversal journals online imported via spreadsheet template encounter an error for at least one user.

Steps to Replicate:
The issue can be reproduced at will with the following steps:

Run the spreadsheet import process with reversal journals having more than 1500 journal lines.
Run online edit.
Run online Post - all three users needs to run the process at the same time for their respective journals.
At least one of the users will get an SQL error.

A SQL error occurred. Please consult your system log for details.

Click OK

Process 347307 ABENDED at Step FTDOCAE_LIBR.GenDocSq.Step08 (SQL) -- RC = 8601 (108,524)

Click OK

CallAppEngine: Application GL_JP: AppEngine error. (2,653) GL_JOURNAL.ProcessJournal.OnExecute Name:LaunchRequest PCPC:2223 Statement:57
Called from:GL_JOURNAL.ProcessJournal.OnExecute Name:LaunchProcess Statement:38
Called from:JRNL_PANELS_WRK.PB_POST.FieldChange Name:post_jrnl Statement:4
Called from:JRNL_PANELS_WRK.PB_POST.FieldChange Name:pb_post_fc Statement:75
Called from:JRNL_PANELS_WRK.PB_PROCESS.FieldChange Statement:28

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

Trace file is showing following error:

PSAPPSRV.12056 (22) 1-89009 07.02.48 0.007000 Cur#0.12056.notSamTran RC=0 Dur=0.000000 XER rtncd=5 msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE 40001) 1205
PSAPPSRV.12056 (22) 1-89010 07.02.48 0.000000 Cur#1.12056.FSDEV RC=0 Dur=0.000000 Rollback




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.