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 Enterprise Performance Management Cloud to Data Management.

  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. Complete the steps for scheduling a maintenance script.

   For more information, see Scheduling Maintenance Scripts in the Job Scheduler.

2. From the Schedule Job page, select Purge All Imported Data.

3. From the 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.