My Oracle Support Banner

Department Hierarchy OTBI Prompt - How To Limit What Dept Trees Appear In Prompt (Doc ID 2854374.1)

Last updated on MARCH 13, 2022

Applies to:

Oracle Fusion Goal Management Cloud Service - Version and later
Information in this document applies to any platform.


 Created an OTBI prompt for Department Hierarchy, where the user selects a department from the department tree to view employees that roll up to the selected department. The prompt is drillable, where the user can drill through the levels of the department hierarchy inside the prompt to locate the department they want to see the roll-up for.

Currently, the Department Hierarchy prompt displays all active department trees. However, we need to be able to control which department trees appear in the prompt for users. We need to suppress certain department trees from appearing in the OTBI prompt. We only want one of our active department trees to appear when the user opens this OTBI prompt.

For example, our cloud environment has two active department trees: DEPT_SECURITY & SIT4_TKSC4
Both of these trees appear currently when the user opens the Department Hierarchy prompt in an OTBI report/dashboard.
However, we only want DEPT_SECURITY tree to appear when the user opens this OTBI prompt.
We do not want users to see the other department tree (SIT4_TKSC4) when using the prompt.

We only want one of our active department trees to appear when the user opens this OTBI prompt.

The business need is that many department trees will be created for a variety of purposes (such as, different trees to control timekeeper security access), but only one department tree contains the full department hierarchy of the whole company, which should be used for reporting purposes. Users will go into reports and want to see employees that roll up to a certain department, based on the full department tree (not the other small department trees). We do not want users to select the wrong trees since they are not meant to be used in reporting and if the user selected them, they would show completely incorrect results.

How can we achieve this?


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.