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

(Doc ID 2297352.1)

Last updated on DECEMBER 04, 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. (note USD is the BASE amount)

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