Filtering my Department OBS is not returning correct results for resources as well as investments

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM On Premise

Issue/Introduction

When we select "Units and Descendents" option for one of the top level OBS nodes, the nodes that are under another top level node unrelated to what we selected are showing in the search results. This happens with projects as well as resources.

Environment

Release : All Supported Clarity releases

Resolution

We found out the OBS parent was wrong in table obs_units_flat_by_mode

The OBS are inserted /changed by PPM Adaptor process - we suggest to open a case with GD team to get this addressed.