EGL9.1: Journal Data Overlapping when GL_JRNL_IMP is Run by Multiple Users Simultaneously with Same Import File Name
Last updated on JUNE 25, 2018
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.
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