Archive Using Batch UI

Complete the following steps to archive data from AAI_WF_PROCESS_ENGINE_ACT_QUE & AAI_WF_PROCESS_ENGINE_ACT_HIST table, using Batch UI.

1. Login to ECM application UI with admin user
2. Create a Data Transformation (DT) of type External Library. Select the wfEngineActDataArchive.sh file as part of DT definition.
3. Add 6 parameters.
4. Create ICC batch using the above DT.
   In the Parameter List select the number of records to be excluded & table information as -- 2,QUE or 3,HIST.
5. Execute the batch by selecting the date beyond which data needs to be archived.

   Note:

   • The first 4 input entries (Input 1 to Input 4) are dummy inputs hence you can provide any value.
   • 5th parameter (Date -YYYYMMDD) is Date in the format of YYYYMMDD.
   • 6th parameter (<table to be archived, QUE/HIS>) is to indicate which table has to be archived (QUE or HIST) & the number of records to be excluded from latest N_ORDER