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 NOVEMBER 15, 2023

Applies to:

Symptoms

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:

1. 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.
   
2. Open JRNL1_WS.xlsm template and click on 'Setup & Defaults' button. Specify address and database details in 'Online Import Control' section.
3. 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

Changes

Cause

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