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 APRIL 26, 2017

Applies to:

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

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

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