Cleanup

The TFORM_GENERATE_VALID_COMBINATIONS program cleans up the previously generated records in the SC_VALID_COMBINATIONS as follows:
DELETE FROM SC_VALID_COMBINATIONS vc 
    WHERE valid_combination_source = 'Generated'

    //If source is specified:
    AND source = <SOURCE>
Note: 
  • If the records are successfully deleted or cleared, commits changes.
  • If an error occurs while deleting the record, the processing is stopped, error message is logged, and returned with error.
  • The task log record is updated with the actual status.