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 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

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

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

or

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

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