When a user is trying to delete the ideas using the Delete Investments Job, the Job is getting completed, but the instances are not getting removed.
Release : 16.0.2
Check the bg-ca logs for further details.
If there are actuals and you did not mark the job to delete actuals the investment will not be deleted.
Check for processes on any of the tabs.
For instance they could be on the investment itself, Tasks, Financial Plans or any other sub objects.
- Normally the logs will show you which object the process is associated.
- If the logs show that it cannot lock the cost plan check the pk_id associated in the bg-ca log. These could be on cost plans, benefit plans, budget plans.
Abort the Processes and delete those instances.
UPDATE bpm_run_processes
SET status_code = 'BPM_PIS_ABORTED'
WHERE status_code ='BPM_PIS_ABORTING'
commit;