Custom BI Reports
Summary:
Content (please ensure you mask any confidential information):
Hi Team,
I am currently working on creating a custom BI query, and I have come across an issue. When querying the PER_USERS table, I notice that certain users such as FAADMIN, anonymous, and FUSION_APPS_CRM_ESS_APPID appear in the results. However, these users do not seem to appear in the standard User Role Membership Reports or on the security console page (Users).
In our custom query, we would like to exclude these users from the results. Therefore, I would appreciate any guidance on whether there is a specific column that can distinguish normal users from FAADMIN, anonymous, FUSION_APPS_CRM_ESS_APPID, and similar accounts.