EGL: Spreadsheet Journal Import(JRNL1) Batch Import Keeps Files Locked With Microsoft Visual Basic Run-Time Error '75': Path/File Access Error (Doc ID 2029197.1)

Last updated on OCTOBER 22, 2019

Applies to:

Symptoms

Issue:
---------
Users can open JRNL1.xls from c:\Uploads, and create the file to C:\users\\documents\jrnl1.xml and then rerun this process as many times as they want and it will work OK. However once they upload the jrnl1.xml file to PeopleSoft through the web interface (either through IE or Chrome) then the file (again C:\users\\documents\jrnl1.xml) loses all permissions and becomes undeletable and they can no longer overwrite it.

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

1. Open JRNL1.xls
2. Add a new journal.
3. Click on 'Home'.
4. Write File to C:\Users\username\Documents\JRNL1.txt
5. Navigate to General Ledger > Journals > Import Journals > Spreadsheet Journals and upload journal.
6. Add a new journal in JRNL1.xls.
7. Click on 'Home'.
8. Write File to C:\Users\username\Documents\JRNL1.txt (overwrite the existing file).

Error:
---------

Microsoft Visual Basic Run-time error '75':Path/File access error

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.