EGL: Spreadsheet Import Journal (JRNL1 and JRNL1_WS) Fails With Invalid SpeedType if SpeedType Has More Than One User (Doc ID 2274180.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
Spreadsheet Journal Import fails with below error when SpeedType Key is defined for more than one User

ERROR
-----------------------
"Imported 0 journals - System ID (Unit, Journal ID, Date) Reference,
Description:

1228 (US001, NEXT, Journal Line No.: 1, 2017-05-11) -, - --Errored : Invalid
SpeedType TEST1"

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > SpeedTypes
2. Create SpeedType TEST1 for User ID GLA1 and GLA2
3. Enter Spreadsheet Journal using above SpeedType
4. Attempt to import the journal and login as GLA2


Refer Replication Steps 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