FAQs for Application Adoption and Usage

This table provides answers to common questions regarding reporting on application adoption and usage for your organization.

Question	Answer
If I select months = 600, will the data be retained for 50 years?	Yes, currently there is no limit. So whatever you select when scheduling the ESS job, the data is retained for that many months. If you pass 600 then 50 years data will be retained. This it ONLY valid after 19C. From 18A to 19B, you could only retrieve 12 months. If you are running the job for the first time, you won't be able to get the data from 50 years.
Why are there times when the "FND_TRACK_USER_ACTIVITY" is Enabled at the site level, and the reports are still not showing the Facts measures?	You need to make sure the "FND_TRACK_USER_ACTIVITY" profile option is enabled as "ENABLED" meaning that it should be in all capital letters.
When is the user session counted as 1 and the record created in the ZCA_BI_USER_Login_ACTIVITY table?	A record is created when a user signs in with their sign-in credentials. This session is valid for 30 minutes and if the user closes the browser and within 30 minutes creates a new session on the same browser, the application automatically redirects without asking for credentials, in which case this session is not counted as a second session, but only counted as one. The best way to check if the user is signed in or not is by checking the Active days. if the user had active days as 1 it means they logged in for that day.
Which table holds the record for when a user logs in?	If the user has provided their credentials and logged in to the FA URL the data is captured for the LOG IN_COUNT as 1 and LOG IN_DURATION as 30 mins if logged out after that. If the user has not logged in but there is any report scheduled agent run on behalf of the user / any approval flow / any REST P+ API flow runs on behalf of the user, LOG IN_COUNT is captured as 1 and LOG IN_DURATION is captured as 0. If the user has neither logged in nor any flow/tasks/agents run on his behalf, then the LOG IN count is not captured. If the user logs in directly to the BI URL not via FA (https://FAurl/analytics) then the LOG IN_COUNT is 0 and LOG IN_DURATION is 0. NOTE: Currently LOG IN is capture only for /fscmUI/faces/FuseWelcome or /crmUI/faces/FuseWelcome of /hcmUI/faces/FuseWelcome NOTE: If a customer is logging into FA URL and a navigates to another application from that login, such as the HCM Application or thee CRM application, the application log-ins are not separately captured.
Is a record generated when a user receives an email, even they don't sign-in? (For example, when a purchase request approval request is received)	If the user signs in through Office 365, (clicking on the link in the mail and using the FA plugin) the sign-in is counted as 1 for the channel "Mail".
What is # of inactive Days in User System Usage SA?	The User System Usage / Resource System Usage subject area supports negative reporting. This means that even if no user was active, instead of returning no rows (which is the usual behavior) all user rows are returned with # of active days 0. Since there is no filter on Time in the report, all the users and days are joined and returned. We advise that you have a filter on Time/User for reporting.
How do I create a report which shows the details of the users who have not signed into the application in Rel13 18B?	You can use User System Usage subject area for negative reporting. The # inactive days shows the days the user has not logged into the application.
What is the difference between the two subject areas "Sales - CRM Resource System Usage" and "User System Usage"?	User System Usage provides the key user adoption metrics at the application user level. Sales - CRM Resource Usage provides the mapping between the application user and the specific resource object.
Why don't my CX Mobile and Microsoft 365 mail applications usage not show in the adoption reports?	For mail (Microsoft 365) and mobile applications, if reports are run on a given day, data from that day will not show until a period of 24 hours has passed. Running the scheduled process 'Refresh BI Reports Audit Data for User Adoption Reporting' will not change this behavior.
What metrics are included in the User System Usage Active Day Facts?	# of Active Users - Count of number of users who were active in the application # of Active Days - Count of days for which users were active in the application. # of Days - Total number of days for a given filter. # of Inactive Days - Count of days for which user was not active in the application. # of Logins - Number of times, a user logged in to the application. # of Users - Total number of Active users in the application. Total Session Duration - Total Time spent by the user in the application.