EGL9.1: Journal Data Overlapping when GL_JRNL_IMP is Run by Multiple Users Simultaneously with Same Import File Name (Doc ID 2069251.1)

Last updated on NOVEMBER 16, 2016

Applies to:

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

Symptoms

Issue

--------

On FSCM 9.1 When GL_JRNL_IMP process is run by more than one users run  at same time with same file name having different journal data, both process instances go to success, with 2 journal IDs created. However Leading process instance run has correct data as provided in flat file, But Journal created from lagging process instance run also has data from flat file being used by leading process instance run.

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

1. Keep 2 flat files ready with same name (say journal.dat) having different journal data
2. In PIA navigate to General Ledger > Journals > Import Journals > External Flat Files.
3. Get the 2 flat files uploaded by different users & hit the Run button at same time to import them.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms