Running the Archive Process

To archive 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. For archiving by country, document type, and date, choose Selection as the Process Type.

  5. Select one of the these values:

    • EP_APPR_AR_CNTY_DCIND_DT (Archive by Cntry, Doc Ind, Dt).

    • EP_APPR_AR_CNTY_DCTYP_DT (Archive by Cntry, Doc Typ, Dt).

    • EP_APPR_AR_CNTY_DT (Archive by Cntry, Dt).

    • EP_APPR_AR_DATE (Archive by Date)

    • EP_APPR_AR_DCTYP_DT (Archive by Doc Typ, Dt)

    • EP_APPR_AR_EMPLID_DT (Archive by Emp Id, Dt)

  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:

    Selecting Row Based Processing is not required for any other platform other than Oracle.

  7. Click the Define Binds link.

  8. Click the Reset Query Bind Variables button.

  9. Enter the appropriate information in these fields:

    • Country

    • Document Type

    • Document end date less than

      The system archives into the History tables documents that are older than the date you entered.

  10. Run the process.