1. Creating Analytics for Risk Management
  2. Synchronize Analytics Data

Synchronize Analytics Data

For analyses to display current data, two jobs must run regularly.

An Access Certification Synchronization job updates reporting tables with changes to owner, manager, and certifier assignments in Oracle Fusion Cloud Access Certifications. (It also updates other elements of Oracle Access Certifications that don't apply to analytics.) It begins running when your organization creates its initial certification. From then on, the job runs once a day. You're expected not to modify this schedule.

A Report Synchronization job updates:

  • All dimensions of the Advanced Access Controls Real Time and Advanced Financial Controls Real Time subject areas.
  • The following dimensions of the Compliance Real Time subject area: Change History, Inaccessible Records, Related Records, Risk > Risk Analysis, Risk > Risk Evaluation, Risk > Treatment Plans, and Unassigned Perspectives. Also, the Assessment Details and Perspective dimensions, but only if they're used with one another.

Some subject-area facts and dimensions are updated in real time (without any job being required to run):

  • In the Compliance Real Time subject area, these include Control Details, Facts - Controls, Facts - Issue, Fiscal Calendar, Issue Details, Process, Process Details, Remediation, Risk > Facts - Risk, Risk Details, and Time.
  • In the Assessment Results Real Time subject area, these include all dimensions, with one exception. If you use either of the Assessment Details or Assessment Results dimensions with the Perspective dimension, run Report Synchronization to update these dimensions.

Schedule the Report Synchronization job to run often enough to reflect the frequency of changes to the data included in your analyses. In a typical environment, it runs daily.

  1. Select the Scheduling tab in the Setup and Administration work area.

  2. In the Scheduling page, select the row that represents the Report Synchronization schedule, then click the Edit option.

  3. In a Schedule Parameter dialog box, enter new values in fields, and make new selections among radio buttons, to define a new schedule. Click the Reschedule button.

You can also run either job on demand: In the Scheduling page, select the row for the job and click the Run Now button.

Note: A third synchronization job updates two subject areas that support analyses of model results. One is Advanced Access Models Real Time, and the other is Advanced Financial Models Real Time. This job must be run manually from the Models page of the Advanced Controls work area. (See Synchronize Model Result Data for OTBI Reporting.)