Configurations for User Adoption Reporting with OTBI

This table provides a list of the ESS jobs used to manage and refresh the data for User Adoption subject areas.

ESS Scheduled Process Name	Details
Process Click History Mapping Data	This process adds flow names to clicks; "stamps" the click information to the click information from the logs. Both the Click area and Application Usage Insights use this data. This job requires that use user have the privilege of ORA_ZCA_POPULATE_CLICK_DESCRIPTIONS_PRIV This job runs automatically by the hour. Users can change the run schedule. For 21C or earlier this process requires the profile option enabled for BI_CH_SA_ENABLED After 21C this process runs automatically.
Click History Data Purge Process	This process aggregates click history data older than 90 days. Both the Click History subject area and Application Usage Insights use this data. This job requires that the user have the privilege of ORA_ZCA_POPULATE_CLICK_DESCRIPTIONS_PRIV The run times for this process can be modified. Values of 90 and 180 are valid values.
Refresh BI Reports Audit Data for User Adoption Reporting	This process populates data for the Resource System Usage and Object Activity subject areas. Application Usage Insights also uses this data. The process accepts 2 parameters: Full Load (Y/ N): Set to N to incrementally capture the audit data. This setting ensures better performance and prevents the deletion of all of the historical audit data you collect. A setting of Y deletes all of your historical audit data regardless of the number of months you enter in the Purge after (Months) parameter. Purge after (Months): Enter the number of months you want to retain the audit data. Entering 12, for example, causes the purging of audit data you collected that's older than 12 months. You always retain the latest 12 months worth of data. If you're starting to capture data today, the audit will start purging a month's worth of data after at the end of the 13 month. This job requires that the user have the privilege of ACM_RUN_CRM_ANALYTICS_REFRESH_JOB_PRIV The profile option FND_TRACK_USER_ACTIVITY needs to be set to "ENABLED" to run.
Click History Mapping Translation Processor	This process populates the descriptions of clicks for the Click History subject area and Application Usage Insights. This job requires that the user have the privilege of ORA_ZCA_POPULATE_CLICK_DESCRIPTIONS_PRIV You need to run this process manually once to get started, and then again if you add a new language.

This shows the privileges, profile options, and roles that a user needs to manage and run the data that is used for the User Adoption subject areas. Set Profile Option Values

Privilege / Profile Option / Role	Details
Run CRM Analytics Audit Table Refresh Job	ACM_RUN_CRM_ANALYTICS_REFRESH_AUDIT_TABLE_JOB_PRIV This privilege permits you to run the "Refresh BI Reports Audit Data for User Adoption Reporting" ESS job.
Run Populate Click Description Process	ORA_ZCA_POPULATE_CLICK_DESCRIPTIONS This privilege permits you to schedule and run these ESS jobs: Process Click History Mapping Data Click History Data Purge Process Cache Application Usage Insights Report Data Click History Mapping Translation Processor
User Session Activity Tracked	FND_TRACK_USER_ACTIVITY This profile option allows the site to run "Refresh BI Reports Audit Data for User Adoption Reporting" ESS job Enable tracking user activity at the session level.
Click History Processing Interval	ORA_ZCA_CHTIMER_FREQ This profile option lets you manage how often new clicks are processed and added to the Click History Data.
Click History Data Maximum Age	ORA_ZCA_CH_DATA_MAX_AGE This profile option lets you manage how long in days Click History data is retained before it is purged.
Enable Click History Logging and Reporting	ORA_ZCA_CH_DISABLE Click history data collection used for click history reporting in OTBI is disabled by default beginning in Update 22D. If you want to use click history reporting from the CRM – CRM Click History subject area in OTBI, you can enable it by changing the ORA_ZCA_CH_DISABLE profile option value to No. If you've already been using this feature, you'll find it disabled in Update 22D and must re-enable it, as a one-time step. Click history logging provides data for click history reports in both OTBI and Application Usage Insights.
BI User System SA Access	FBI_USER_SYSTEM_USAGE_TRANSACTION_ANALYSIS_DUTY This role lets you view and report with the User Adoption and Click History subject areas.