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.