Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

In OTBI report I'm trying to pull Organization hierarchy level1 and organization hierarchy level2,

Question
1
Views
0
Comments

I'm getting multiple rows like both active and inactive, so how to pull top most one which is active...