3.7 Cash Flow Table Cleanup

This module discusses the procedure to delete data from Cash Flow Output Tables. During the delete process, partitions of Output Tables are truncated. The procedure deletes the data from Output Tables permanently and no backup is retained.

To clean up the Cash Flow Output, follow these steps:

1. Navigate to Operations and Processes menu, and select Scheduler.
2. Select Define Batch. Create a new batch by entering Code, Name and Description.
3. Save the batch.
4. Navigate to Define Task.
5. Select the Batch created above from the Batch drop-down list.
6. Click the Add button.
7. Enter the following details in the Task Details Section:
   • Task Code: Enter a Code for the task.
   • Task Name: Enter Name for the task.

     The Task Name must be alphanumeric and must not start with a number. The Task Name must not exceed 60 characters in length. The Task Name must not contain any special characters except underscore (_).

   • Description: Enter the Task Description. Special characters are not allowed in Task Description. Words like Select From or Delete From (identified as potential SQL injection vulnerable strings) should not be entered in the Description.
8. Select the Task Type as REST.
9. Select Batch Service URL as DMT_SERVICE.
10. Select Component as Transform Data.
11. Enter the following mandatory Task Parameters:
    • Name: Select Name as CASH_FLOW_OUTPUT_DEL
    • Extra Parameters: Enter the following extra parameters:
      • TABLE_NAME: Name of the Output Table. You can enter the table name in Upper or Lower case. Only one table is allowed at a time. The following tables store the Cash Flows/Edits output.

        FSI_O_CFE_OUTPUT_HIST

        FSI_O_CFE_MESSAGES_HIST

        FSI_O_CFE_EDITS_MESSAGES_HIST

      • EXECUTION_ID_VALUE: Enter the Execution ID of Cash Flow Process
    • Use Effective Date: Select this as YES or NO. This parameter does not impact on Cash Flow Table Cleanup functionality.
12. Save the Task.
13. Navigate to Schedule Batch and execute the batch created above created batch with Batch ID and MIS Date.

For more information, see the Scheduler Service.