EGL : Flat File Journal Import (GL_JRNL_IMP) Fails With "Invalid Account value" When Using Control Accounts

(Doc ID 1579072.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

When attempting to upload a flat file with a control account the following error occurs:

ERROR
-----------------------
(GL_JRNL_IMP.PROCESS.LogError) (PeopleCode)
Process 380162 ABENDED at Step GL_JRNL_IMP.PROCESS.LogError (Action PeopleCode) -- RC = 4
ROLLBACK


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. As per PeopleBooks, change prompt tables of record JIMP_LN_WRK for fields account and ALTACCT to enable control accounts in a journal.
2. Use a control account in the flat file.
3. Upload a flat file- receive error  - Invalid Account value

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