E-TR: Tree Import Fails With First Operand Of . Is Null, So Cannot Access Member Number
(Doc ID 2638064.1)
Last updated on FEBRUARY 01, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.57 and laterInformation in this document applies to any platform.
Symptoms
Tree Import process fails with the below error message when the input file has more than 4 Levels -
First operand of . is NULL, so cannot access member Number. (180,236)TREEMOVER_AET.TREE_LEVEL_FLAG. FieldFormula Name:importTreeLevel PCPC:3008Statement:53 Called from:TREEMOVER.Import.GBL.default.1900-01-01.Step01.OnExecute Statement
Trace shows failure on TREEMOVER_AET.TREE_LEVEL_FLAG.FieldFormula pcode line when processing LEVEL5 input line:
&LEVEL_NUM = Value(RTrim(&LEVEL_REC.TREE_LEVEL_NUM.Value));
Fetch Field: PSTREELEVEL.TREE_LEVEL_NUM Contains Null Value
Input file has a Level 5 (as below) but null is getting assigned to it. LEVEL5 line looks the same as prior LEVEL4 line which is processed successfully:
4ALEVEL4 4 N
4ALEVEL5 5 N
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 |