EGL9.2: Spreadsheet Journal Import(JRNL1_WS) Statistical Journals Entered With Statistical Code Fail With 'Errored: A statistical amount is invalid on line n' (Doc ID 2304568.1)

Last updated on SEPTEMBER 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:
-------

Unable to import statistical journals using statistical code method using spreadsheet import template(JRNL1_WS)

Steps to Replicate:
---------------------
1. Set up a statistical code.
2. Open spreadsheet journal import template JRNL1_WS & add a new sheet.
3. Enter journal header details.
4. Enter at least 1 row with statistical code & statistical amount populated along with foreign/base amount.
5. Check the journal edit option in 'Define Options & Defaults' & then click to import the sheet.
6. Uncheck the journal edit option in 'Define Options & Defaults' & then click to import the sheet.

Please see replication screenshots for more details.

Error:
------
Imported 0 journals - System ID (Unit, Journal ID, Date) Reference, Description:
1228 (US001, 0000105017, Journal Line No.: 2, 2017-04-30) -, Stat Amt Test --Errored : A statistical amount is invalid on line 2.

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