EGL9.2:Spreadsheet Journal Import (JRNL1_WS) Results to Error: 'Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:' ' Invalid decimal positions on amount value nnn.nn for currency'

(Doc ID 2332674.1)

Last updated on DECEMBER 04, 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:

Using the new spreadsheet import template - JRNL1_WS.xlsm - importing lines with Currency field value imports 0 journals with below error/s:

  'Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:
  Check the field length of the fields, Check the decimal positions of the amount fields'

  Sometimes, the error could be like below:

  'Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:
  1232 (<BU>, NEXT, Journal Line No.: 2, yyyy-mm-dd) -, test --Errored : Invalid decimal positions on amount value -nnn.n for currency .
  1232 (<BU>, NEXT, Journal Line No.: 1, yyyy-mm-dd) -, test --Errored : Invalid decimal positions on amount value nnn.n for currency.'


Steps to replicate:

1.  Using spreadsheet journal import (JRNL1_WS.xlsm), populate the journal details but use Currency field value = <blank>
2.  Import the journal using 'Import Now' button.

Replication screenshots attached. 

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