My Oracle Support Banner

EGL9.2: Spreadsheet Journal Import(JRNL1) Error Message Doesn’t Show Invalid Account Value, When More Than One Chartfields Have Invalid Value. (Doc ID 2340779.1)

Last updated on MAY 12, 2021

Applies to:

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



While importing in batch mode, error message doesn’t show invalid Account value, when more than one chartfields have invalid value.
If only Account Chartfield has invalid value, but not other chartfields have, it shows the a particular account value that is invalid.

Steps to Replicate:
1. Open JRNL1.xlsm template & create a new sheet
2. Enter details for journal header & line. In lines enter at least 1 line with an invalid Account value.
3. Click on Home button & then on Write File button. Click Ok.
4. In PIA navigate to General Ledger > Journals > Import Journals > Spreadsheet Journals
5. Create a run control & upload the file created in step 3.
6. Click on Run & select 'GL_EXCL_JRNL'.
7. Once process completes check import log.
8. Create another sheet & enter journal header.
9. Enter lines with at least 1 line having an invalid Account & invalid department value.
10. Repeat step 3 to 7.

Please see replication screenshots for more details.

Actual Behavior:
On step 7, import log shows the invalid Account value.
On step 10, import log shows the invalid Department value, but not Account value.

Expected Behavior:

Import log should show, both invalid account & department value.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.