Creating a Schedule to Load Your Data Regularly

When you have specified which Offerings and Functional Areas to load by creating a Load plan in Configuration Manager, you schedule that load plan to load data regularly. For example, you might want to perform an incremental data load once per week on Sunday at midnight. You typically schedule the data load to run during off-peak hours. In addition, if you are loading Fusion Applications data from an Oracle Cloud Storage Service, then you must schedule the data load so that it starts after the Cloud Extract (that is, from Fusion Applications source into Oracle Cloud Storage Service) has completed.

To create a schedule to load your data regularly:
  1. In Configuration Manager, select the Manage Load Plans link on the Tasks pane.
    Description of GUID-282F7F2F-D95D-41D0-8F59-A5910FD4D917-default.gif follows
    Description of GUID-282F7F2F-D95D-41D0-8F59-A5910FD4D917-default.gif
  2. In the Load Plans list, select the load plan that you want to schedule.
  3. Select the Schedules tab.
  4. On the Schedules toolbar, click the Add icon (Add icon).
  5. Specify the following information about the load plan:
    • Context — The ODI context to be used when the load plan is run. Note that Global is the only supported context.
    • Local Agent — Select OracleDIAgent.
    • Log Level — The level of logging information to retain. Configuration Manager uses Oracle Diagnostic Logging.
    • Status — Specify ‘Active’.
    • Recurrence — Specify the frequency of data loads.
  6. Click Schedule.
    When you have scheduled a load plan, you monitor the load plan executions in Configuration Manager, as described in Monitoring and Diagnosing Data Load Issues