My Oracle Support Banner

EGL9.1 - 9.2: Spreadsheet Journal Import(JRNL1) While % is Used In Journal Header or Line Description Encountered "First operand of . is NULL" or "Invalid userid or password. Please check if your login information is invalid or expired" (Doc ID 2001889.1)

Last updated on MAY 03, 2023

Applies to:

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


When attempting to import Spreadsheet journal with % in journal header or line description the following error occurs.

Invalid userid or password. Please check if your login information is invalid or expired.


JRNL1.xlsm fails with First operand of . is NULL, so cannot access member GetCount. (180,236) WEBLIB_GL.JOURNAL_ID.FieldFormula  Name:Import_Journal  PCPC:57723  Statement:712  
Called from:WEBLIB_GL.JOURNAL_ID.FieldFormula  Name:Iscript_Excel_Journal Statement:1024

Steps to Replicate:
1. Open JRNL1.xlsm
2. Setup new sheet
3. Enter New Journal that includes a % in the journal line description
4. Enter lines
5. Import now
6. Receive error
7. Remove % from description
8. Import now and see successful import


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.