My Oracle Support Banner

EGL 9.2: When Using Spreadsheet Journal Import (JRNL1/JRNL1_WS) Exchange Rate and Base Amount are 0 or Blank After Edit (Doc ID 2297352.1)

Last updated on MAY 31, 2018

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 transactions in foreign currency the base amount and exchange rate are not populated.

Exchange rate should be current exchange rate and base amount should be calculated based on the foreign amount entered.


  1. Select Edit Journal(s) options on the Spreadsheet Journal Import Setup and Defaults page (using JRNL1/JRNL1_WS)
  2. Enter spreadsheet journal with transaction in foreign currency
  3. Click online import and verify results on Journal Entry page
  4. Journal Edit Status = V, Base Curr is populated, Base Amount and Exchange Rate are null, Total Debit and Credit = 0.00





To view full details, 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 a vibrant support community of peers and Oracle experts.