Schedule Reload of Data

You can schedule reload of the activated functional areas and deployed custom data configurations to ensure that all the data in these functional areas and custom data configurations is completely reloaded. You can configure different refresh schedules for individual functional areas and custom data configurations.

The system performs data reloads as part of the Data Maintenance refresh. The Data Maintenance tab lists the schedules that you add and the system performs the refresh based on these schedules.

This capability is available in a phased rollout. Reach out to Oracle for additional information.

For Oracle Fusion Data Intelligence, you can schedule a periodic full reload for functional areas such as General Ledger and Order Management. You can schedule a full reload of maximum three functional areas. When you select the functional areas for full reload, ensure that you select the dependent functional areas as well.

You may want to fully reload the data for a functional area in these sample scenarios:

• The Finance department wants to do full reload of the general ledger (GL) data at the beginning of the month to make sure all data is fresh and clean for the monthly GL entries and the analytics and report generation.
• At the beginning of every quarter, all data related to Purchase Orders is updated with returns, refunds, and any adjustments. In this scenario, revenue recognition needs to take all the latest Purchase Order data to compute all numbers and create accurate reports. Hence, a full reload of the order data is required on the 1st of every fiscal quarter that can be different from the calendar quarter.

You can check the refresh summary in two ways:

• View details of the requests on the Request History page.
• View the DW_WH_REFRESH_SUMMARY data warehouse table.

Ensure that Scheduled Full Data Reload is enabled in Pipeline Features under the Generally Available Features tab on the Enable Features page prior to scheduling periodic full reload. See Enable Generally Available Features.

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 Reload Data Schedule.
   
   

   

   
   
5. Click Add to specify the refresh schedule and load type for either a functional area or custom data configuration.
6. In Module Settings, select either Functional Area or Custom Data Configurations in Module Type, select the applicable name in Module Name, and Full Reload as Load Type.
   
   

   

   
   
7. In the Data Refresh Schedule section in Module Settings, select the frequency interval such as daily, weekly, monthly, quarterly, or yearly.
8. Based on the selected frequency interval, select the specific day of the week, month, a day in the first month of the quarter, or a month and day of the year.
9. Click Save.