Oracle Transactional Business Intelligence

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

Oracle HCM - inactive organisations in prompts

Question
2
Views
0
Comments

Hello,

I have some organisations (ex : services or legal enity) that are inactive in the system (EX : OLD SERVICE).

It doesn't affect any reports but it still appears in the prompts (see example below).

Is there a way to exclude those services from the choice list ? without having to use a SQL function in each invite of data.

Thanks in advance,

Jacqueline