My Oracle Support Banner

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:

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

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

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
Symptoms
Changes
Cause
Solution
References


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