My Oracle Support Banner

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 JULY 22, 2020

Applies to:

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


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

“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);
  If &bSetBasedTreeLoad And
  SQLExec("SELECT COUNT(*) FROM PS_HR_JTREE_TAO", &nRootChildCount);
  &nRootChildCount = %This.getDRTotalCount(%This.sRootEmplId, %This.nRootEmplRcd);
  &iobjRootNode = &iobjTree.InsertRootBatchMode(%This.sRootNodeName, &nRootChildCount);
  If &iobjRootNode = Null Then
  Return False;
  &iobjRootNode.decription = %This.objTreeNodeKey.getPersonNameByTreeKey(%This.sRootNodeName);


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- (1000,1556)

Tree Not Open (92,3051)

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


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

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