Deleting Archived Rows

To delete archived ePerformance documents, follow these steps:

1. Access the Archive Data to History page (PeopleTools, and then Data Archive Manager, and then Archive Data to History).

2. Create a run control ID.

3. Select EP_APPR (ePerformance Docs Archive) as the Archive Template.

4. To delete old documents, choose Delete as the Process Type.

5. From the Batch Number field, select the batch number that was assigned to the archive process.

6. If you are using an Oracle database, select Row Based Processing and then enter a number (usually 10000) in the Commit Frequency field.

   Note:

   Rows have to be in the History tables to be deleted from Transaction tables.

7. Select the Audit Row Count check box.

8. Run the process.

Note:

If you need to restore rows from History tables back to Transaction tables, select Rollback as the process type and then select the query that meets your needs. You also need to reset the query bind variable fields (Country, Document Type, Doc end date greater than, and Doc end date less than).