EGL9.2: Spreadsheet Journal Import (JRNL1_WS) Performance Issue or Deadlock Errors While Multiple Users Concurrently Importing Journals
(Doc ID 2493442.1)
Last updated on OCTOBER 19, 2021
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When running online import concurrently/simultaneously to import multiple journals in parallel using Spreadsheet import template JRNL1_WS getting performance issue and import fails most often with a deadlock error
Below errors were observed in App server log file for a MS SQL server database:
Steps to Replicate:
- Copy JRNL1_WS.xlsm , JRNLMCRO_WS.xlam and GLLOG.xlt to same folder in the workstation. The files can be copied from <PS_Home>/Excel directory.
- Open JRNL1_WS.xlsm template and click on 'Setup & Defaults' button. Specify address and database details in 'Online Import Control' section.
- Multiple users to import simultaneously journals with large number of lines.
Note: If already upgraded to 9.2 PUM Image 37 then deadlock message may be seen in Message log of GL_JRNL_UPLD process
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