EGL9.1: Spreadsheet Journal Import(JRNL1) Imported Journal Passed GL_JEDIT Process Even If MONETARY_AMOUNT and FOREIGN_AMOUNT have Different Signs (Doc ID 2169117.1)

Last updated on APRIL 26, 2017

Applies to:

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

Symptoms

Issue
---------
Uploaded journal thru Spreadsheet Import gets validated with amounts in MONETARY_AMOUNT and FOREIGN_AMOUNT in different signs.
This is even when 'Journal Amount Errors Options' in Journal Options page is set to 'Recycle' at Business Unit level and was set to 'Default to Higher Level Value' at Ledgers for a Unit and Source Levels.

Environment
----------------
FSCM 9.1 Bundle 9

Steps
---------
1.  Upload journal via spreadsheet journal import
2.  Run GL_JEDIT process

Note:  Ledger Group has four (4) ledgers with different Base Currencies

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