CLRT-78778 If a portfolio is deleted the sync schedules are not deleted and remain scheduled
I was told there isn't a work around for this bug apart from upgrading to 14.4, so I hope this is useful for anyone else impacted by this
Identify the orphan schedules where portfolio has been deleted
SELECTj.id job_idFROMcmn_sch_jobs jINNER JOIN cmn_attribute_value_sets b ON j.id =b.business_object_instance_idINNER JOIN cmn_attribute_values v ON v.attribute_set_id = b.idWHERE attribute_id = 5076035AND v.attribute_value NOT IN (SELECT TO_CHAR(id) from pfm_portfolios)AND j.status_code = 'SCHEDULED'
Go to Jobs, Scheduled Jobs
Thanks for sharing.
Thanks for sharing this with the community Andrew!
CLRT-78778 - Work around - Orphan portfolio sync schedules if portfolio deleted
A couple months ago this would have saved me a couple hours of grief.
Good to know it's out here!