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 12, 2021

Applies to:

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

Symptoms


ACTUAL BEHAVIOR
---------------
When using GL spreadsheet upload for transactions in foreign currency the base amount and exchange rate are not populated.



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

STEPS
-----------------------

  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

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.