1. Administering Oracle Fusion Analytics Warehouse
  2. Configure Oracle Fusion Analytics Warehouse Data
  3. Schedule Periodic Full Reload of Functional Area Data (Preview)

Schedule Periodic Full Reload of Functional Area Data (Preview)

You can schedule periodic full reload of the applicable functional areas such as General Ledger and Order Management to ensure that all the data in these functional areas is completely reloaded. You can schedule a full reload of maximum three functional areas.

WARNING:

When you schedule a full reload, the incremental loads take a longer time and depending on the initial extract date, the incremental data load may take days to complete the extraction.
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.

Ensure that Scheduled Full Data Reload is enabled under Pipeline Features on the Enable Features page prior to scheduling periodic full reload. See <xref to Make Preview Features Available>

  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Navigator menu, click Console, and then click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Global Configurations, click Pipeline Settings.
  4. On the Pipeline Settings page, click Warehouse Full Relaod Schedule.
  5. In the Warehouse Full Reload Schedule tab, in Full Reload Frequency, select the frequency type such as weekly, monthly, or quarterly.
  6. Based on the selected frequency type, select the specific day of the week, month, or the first month of the quarter.
  7. Select the check boxes for the functional areas whose data you want reloaded fully at the specified period.
  8. Click Save.