Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!