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
Refresh BI Reports Audit Data for User Adoption Reporting	This process populates data for the Resource System Usage and Object Activity subject areas. 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.

ESS Scheduled Process Name

Details

Refresh BI Reports Audit Data for User Adoption Reporting

This process populates data for the Resource System Usage and Object Activity subject areas.

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.

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.
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.
BI User System SA Access	FBI_USER_SYSTEM_USAGE_TRANSACTION_ANALYSIS_DUTY This role lets you view and report with the User Adoption subject areas.

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.

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.

BI User System SA Access

FBI_USER_SYSTEM_USAGE_TRANSACTION_ANALYSIS_DUTY

This role lets you view and report with the User Adoption subject areas.