My Oracle Support Banner

EGL9.2: Spreadsheet Journal Import (JRNL1_WS) Journal Gets Imported Without Converting Base Amounts, If 'Edit Journal(s)' Option Is Checked (Doc ID 2276607.1)

Last updated on AUGUST 29, 2018

Applies to:

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

Symptoms

Issue:
-------

Spreadsheet Journal Import(JRNL1_WS) Journal gets imported without converting base amounts, If 'Edit Journal(s)' option is checked on import setup page.

Steps to Replicate:
---------------------
1. Save all JRNL1_WS, JRNLMCRO_WS, GLLOG on the same folder
2. Enter journal data in spreadsheet with lines having with blank base amount & exchange rate
3. Select the 'Edit Journal(s)' check box on the set up page
4. Click on the button to import journal.

Please see replication screenshots for more details.

Actual Behavior:
------------------

Journal is imported with blank exchange rate & base amount.

Expected Behavior:
-------------------
Imported Journal should have correct exchange rate & base amount.

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.