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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.