11.4.1.4.1 Setting up Purge Batch for the FSI_O_FTP_ADJ_TP_VALUES Table

To delete records containing average life/duration for adjustment rate calculations from the FSI_O_FTP_ADJ_TP_VALUES table.

To create a Batch:

1. Click the Batch Maintenance option under Operations.

   Figure 11-27 Batch Maintenance page

   
   

   

   
   
2. Click the Add icon to create a Batch for deleting records from the FSI_O_FTP_ADJ_TP_VALUES table.
3. Enter the Batch Name and Description. Select the Duplicate Batch and Sequential Batch, or Duplicate Batch or Sequential Batch options if required. Click Save.
4. Search the created Batch using the Search criteria if required. The Batch is displayed. Select the Batch to add the corresponding task to it.
5. Click Add to add the task to the selected Batch, enter the description Task Definition page. Select the component of the task as Transform Data.
   Enter the required parameter details as follows:

   • Datastore Type: Leave the default value of “EDW”.
   • Datastore Name: Leave the default value.
   • IP Address: Leave the default value.
   • Rule Name: Purge ADJ tp values.
   • Parameter List: (Date Range): ‘From Date’, ‘To Date’ Format('YYYYMMDD').
6. To execute the Batch, click the Batch Execution option under Operations. Select the Batch, which you want to execute using the search criteria. Select the Batch using the corresponding check box.

   Figure 11-28 Batch Search page

   
   

   

   
   
7. You can also use the Schedule option if you want to schedule a Batch for later or recurring processing. Click Execute Batch. A message is displayed: Batch Triggered Successfully. Click Ok.
8. To view the Batch Processing Report, click the Batch Processing Report option under. Expand the Execution Date.

   Figure 11-29 Batch Processing Report