Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Transactional Business Intelligence

Oracle HCM - inactive organisations in prompts

Question

Views

Comments

Jacqueline GRANDIN Rank 2 - Community Beginner

Mar 19, 2025 8:43AM in Oracle Transactional Business Intelligence

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