Purge All Imported Data

Clear all imported data from your data tables.

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 schedule the script to run now, see Scheduling a Job to Run Now.

To schedule the script to run later, see Scheduling a Job to Run Later.

When scheduling the Purge All Imported Data script, specify the following:

• Confirm Delete All Imported Data: Select Y to launch a confirmation message before executing a purge. Else, select N.
• Reason: Specify the reason for executing the purge.