Use the script below to clean up old conversion Application Engines, such as SM%_CNVAEs, from system process requests. The script removes PRCSMULTI from the process list in process definition ‘PRCSDEFNPNL’, except for the SM_ES_I9CNV and SM_ES_INVCNV processes, which will remain in the process lists. Change the LASTUPDDTTM to execute the cleanup for more recent entries.
SELECT * FROM PS_PRCSDEFNPNL WHERE PRCSNAME like 'SM%CNV%' and PNLGRPNAME='PRCSMULTI' AND PRCSNAME NOT IN ('SM_ES_I9CNV','SM_ES_INVCNV') AND PRCSNAME IN
(SELECT PRCSNAME FROM PS_PRCSDEFN WHERE PRCSNAME like 'SM%CNV%' AND LASTUPDDTTM < TO_DATE('06/01/2024','MM/DD/YYYY'));