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