Oracle Cloud Infrastructure Documentation

Override Data Pipeline Schedules for Functional Areas (Preview)

You can remove a functional area from the standard incremental schedule and set a separate schedule with lower frequency of run to prioritise your data pipelines and run timings.

You can select one or more functional areas and schedule to run incremental at a lower frequency than the standard incremental job. If the incremental refresh is scheduled for Daily, then you can choose one or more functional areas to schedule them to run Weekly or Monthly or Quarterly or Yearly. If the incremental refresh is scheduled for Weekly, then you can choose one or more functional areas to schedule them to run Monthly or Quarterly or Yearly.

If the incremental refresh is weekly, then it runs on a certain day of the week. Thereafter, if you do an override for Monthly on a certain day of the month, then you can't piggyback on incremental since weekly incremental (certain day of the week, let's say Monday) may not run on the desired Day of the Month (let's say 1st). In this scenario, you can create schedules to override different modules on different days of the week and override different modules on the same day of the week.

Ensure that Functional Area Schedule Override is enabled in Pipeline Features under the Preview Features tab on the Enable Features page . See Make Preview Features Available.

  1. Sign in to your service.
  2. In Oracle Fusion Data Intelligence Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Pipeline Settings.
  4. On the Pipeline Settings page, click Functional Area Schedule Override.

    Functional area schedule override option

  5. In the Functional Area Schedule Override tab, select the applicable functional areas and click Update Schedule.
    To set the schedule for an individual functional area, click the Action menu for the applicable function area and click Edit Schedule.
  6. In Schedule Settings, specify the data refresh schedule by selecting a value in the Standard Data Refresh Interval field and the dependent values for Start Day and Month when applicable.

    Schedule Settings dialog

  7. Click Save.