Maintain Data Table by Location

Use Maintain Data Table by Location to delete data for a specific location by period or category.

Note:

To delete all locations for an application, use the Maintain Data Tables by Application option. This option enables you to delete data across all locations associated with a selected target application. For more information, see Maintain Data Table by Application.

Maintain Setup Data uses a Mode parameter, which enables you to either preview or delete invalid data.

The parameters are:

• Location

• Start Period

• End Period

• Category

Note:

If you need to delete multiple period mapping but you are unsure which integrations include period mappings, leave Location and Category blank if you want to delete all the period mappings.

To run the Maintain Data Table by Location task:

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 to the right of the Maintain Data Table by Location task.

3. From the Run Script: Maintain Data Table by Location page, and then from the Location drop-down, select the location from which to delete data.

   To delete data from all locations, leave the Location field blank.

4. From Start Period, select the starting period from which to delete data.

5. From End Period, select the ending period from which to delete data.

6. From Category, select the category data to delete.

   To delete all category data, leave this field blank.

7. Click OK.