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 JUNE 13, 2017

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.

Cause

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