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.
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
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
Symptoms |
Cause |
Solution |
References |