My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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




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.


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.