Purge All Imported Data

Use Purge All Imported Data to clear all imported data from your data tables. This option enables you to clear data from the system so that you can start over when loading data.

When executed, the Purge All Imported Data deletes the following:

  • Mapping audit used for loading
  • Audit information about the data load
  • Process load status
  • Process parameters

Note:

There is no backup to recover any purged data. It is recommended that you use extreme caution before executing this process.

After the purge, note the following:

  • You cannot view any data in Workbench for any POV.
  • You cannot drill down from the Oracle Fusion Cloud Enterprise Performance Management to Data Integration.

    Note:

    Drill regions are not deleted as part of the purge process. If you need to delete a drill region, then delete it manually.
  • You cannot restore maps for the given POV.

Note:

All setup data for example application registration, import format, and mapping are retained and not impacted by the purge process.

To run the Purge All Imported Data script:

  1. From the Data Integration home page, and then from the Actions menu, then from the Other actions drop-down, select System Maintenance Tasks.

  2. From the System Maintenance Tasks page, click Image shows the Arrow icon. to the right of the Purge All Imported Data task.

  3. From the Run Script: Purge All Imported Data page, and then from Confirm Delete All Imported Data, select Y (yes) to launch a confirmation message before executing a purge.

    Otherwise, enter N (No).

  4. In Reason, specify the reason for executing the purge.

  5. Click OK.

    The message: Custom script executed initiated with Process ID: XXX is displayed (where XXX is the process id number generated for job). You can access the log from the Process Details page.