QUERY_TREE_HR Error When Saving: 'Overlapping Node Number Range of a Node with its Parent or Sibling'

(Doc ID 1919147.1)

Last updated on FEBRUARY 15, 2018

Applies to:

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


QUERY_TREE_HR has duplicate nodes and it is erroring on save with following error :


Overlapping node number range of a node with its parent or sibling: Test Range: 204168878 - 235294116  Node: HR RPTING VWS 917156527 - 235294116  Parent: PERS ADMN ACCESS GRP 204168878 - 240753462692  Sibling EMPLOYEE REGISTRY BR 140733428682149 - 294117645  (25,21)

An internal error in node numbering has occurred. A node has a range that overlaps its sibling's or parent's node number range.  Unable to save tree.

Reopen the tree and repeat your edits. If you get this message again, you may need to renumber the tree's internal node numbers by running the Tree Utilities program Reset Tree Node Gaps utility.



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