EGL 9.2: When using Spreadsheet Journal Import (JRNL1/JRNL1_WS) Exchange Rate and USD amount Is 0 After Edit

(Doc ID 2297352.1)

Last updated on AUGUST 18, 2017

Applies to:

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


When using GL spreadsheet upload for foreign units (non USD) USD amount is becoming 0 .

Users are facing an issue where our Germany business user is using General Ledger spreadsheet upload for all their journal entries,  for some journals created they are seeing that the USD amount calculated in 0, because the exchange rate shows 0.

Exchange rate should show as the current rate.


  1.  Create a journal with Spreadsheet journal (JRNL1/JRNL1_WS) for entries with a foreign currency BU
  2.  Upload Entries
  3.  Edit Journals online


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