Job Tree Builder (HR_TREEBLD_E) Errors in PT 8.55: "Tree Not Open (92,3051) NULL parameter was passed to a Tree Object method (92,3004)" (Doc ID 2138503.1)

Last updated on APRIL 07, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

In PeopleTools v8.55, Job Tree Builder process (HR_TREEBLD_E) results with errors in methods "InsertRoot" or "InsertRootBatchMode" in Application Package HR_JOB_TREE_BLDR.TreeBuilderBase.createTree.

Replication Steps:
1.  Navigate: Main Menu > Set Up HCM > System Administration > Utilities > Job Tree Builder > Tree Builder Run Control
2.  Set Run Control Parameters the Tree Builder application engine
3.  Process Ends in error

Customers who are upgrading have reported similar issue in steps:

HCM 9.1 to 9.2 (through Update Image 16) Upgrade
Task 8-11-2: Running Job Tree Builder


Pre-analysis:
“InsertRoot” or “InsertRootBatchMode” methods returned null values. Null parameter was passed to a tree object method.
method createTree
  /+ &bSaveAfterCreate as Boolean, +/
  /+ &bLeaveOpen as Boolean +/
  /+ Returns Boolean +/

............
............

  /* create root node using old api if before PT 8.55*/
  #If #ToolsRel < "8.55" #Then
  &iobjRootNode = &iobjTree.InsertRoot(%This.sRootNodeName);
  #Else
  If &bSetBasedTreeLoad And
  (HR_JOBTREE_AET.ACCESS_TYPE.Value = "4" Or
  HR_JOBTREE_AET.ACCESS_TYPE.Value = "5" Or
  HR_JOBTREE_AET.ACCESS_TYPE.Value = "6") Then
  SQLExec("SELECT COUNT(*) FROM PS_HR_JTREE_TAO", &nRootChildCount);
  Else
  &nRootChildCount = %This.getDRTotalCount(%This.sRootEmplId, %This.nRootEmplRcd);
  End-If;
  &iobjRootNode = &iobjTree.InsertRootBatchMode(%This.sRootNodeName, &nRootChildCount);
  #End-If;
  If &iobjRootNode = Null Then
  Return False;
  Else
  &iobjRootNode.decription = %This.objTreeNodeKey.getPersonNameByTreeKey(%This.sRootNodeName);
  End-If;

ERROR
-----------------------

Initialization steps complete. (1000,22329)

Executing app engine plug-in HR_TREEBLD_E.01START. (1000,22330)

Building Tree: Setid=' ', SetCntrlValue=' ', Tree Name='COMPANY_DIRECTORY', EffDt='2016-03-22'. (1000,22340)

Tree nodes for Tree COMPANY_DIRECTORY will be populated by fetching directly from the Direct Reports flat tables. (1000,1564)

Node temp table load complete at 2016-03-22-14.48.21.000000 (1000,1556)

Tree Not Open (92,3051)

NULL parameter was passed to a Tree Object method (92,3004)

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