Query to Fetch the Inactive Users in Oracle Fusion BI Report

SELECT * FROM “FUSION”.”ASE_USER_VL” “ASE_USER_VL”
where EXISTS (select ‘1’ from “FUSION”.”PER_USERS” “PER_USERS”
where UPPER(“ASE_USER_VL”.”USER_DISPLAY_NAME”) = UPPER(“PER_USERS”.”USERNAME”)
AND (“PER_USERS”.”ACTIVE_FLAG” = ‘N’ OR “PER_USERS”.”SUSPENDED” = ‘Y’))

Leave a Reply

Your email address will not be published.