EGL: Spreadsheet Journal Import(JRNL1) Allows to Import Amounts to 3 Decimal Positions (Doc ID 622318.1)

Last updated on APRIL 26, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.
***Checked for relevance on 03-17-2011***
***Checked for relevance on 11-13-2012***
***Checked for relevance on 04-26-2017***
***Checked for relevance on 06-14-2015***
***Checked for relevance on 12-29-2016 & Updated***
This document was previously published in Customer Connection Solution 200766260


Symptoms

Issue:
-------

Spreadsheet import or Flat file journal import allows imports of amounts to 3 decimal positions when the currency allows only 2 decimal positions.

When creating the journal online, the Currency Control field Foreign_currency restricts the field format.  If entering enter 3 decimals amount  for USD currency online, it throws warring message.

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