EGL9.2: Spreadsheet Journal Import(JRNL1_WS) Unable To Import Journal Using Write To File Option (Doc ID 2268694.1)

Last updated on JUNE 01, 2017

Applies to:

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

Symptoms

On : 9.2 Image 20 +, Spreadsheet Journal Import

Unable to import journal using Write To File option from JRNL1_WS template

When trying to import a journal using the WS journal upload template via the Write To File option, 0 journals are imported.
The GL_EXCL_JRNL process runs to Success but nothing has imported/uploaded.


ERROR
-----------------------
0 journals are imported.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1.  Create Journal with JRNL_WS
  2.  Click home and then Click Write to file and save the file as a .txt
  3.  In PIA navigate to: General Ledger > Journals > Import Journals > Spreadsheet Journals
  4.  Create a run control and select the newly created journal.

 

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