I need more information about the 'Delete Process Instances' Job

Document ID : KB000055230
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:   
I need more information about the 'Delete Process Instances' Job. What table does this job delete from?
If this is coming from the BPM_RUN PROCESSES table, how does the 'finish date from' and the 'finish date to' correlate to the start and end date in the the table?


Solution:   
The parameters on the Delete Process Instance job for the "Finish From Date" and the "Finish To Date" is a date range that relates to the BPM_RUN_PROCESSES.END_DATE field

Example:
When the user enters "Finish From Date" = 01/01/05 and "Finish To Date" = 01/31/05 on the job parameters page, then it will delete all process instances that have an end_date that falls within that range

If you run the job and do not enter any values for any of the parameters, you are telling the job to delete all process instances that have a status of 'Cancelled' or 'Done' regardless of a finished date. Running this job without any parameters may impact performance of your application. It is recommended that you specify some parameters when executing this job.

Typically, 'Cancelled' process instances do not have a Finish Date, therefore you would not specify a Process Instance Status of 'Cancelled' along with a Finish Date From and a Finish Date To range. Therefore, the Finish Date range is most applicable to process instances that have a status of 'Done'.

Delete process instance operation deletes one or more rows from the following tables:
BPM_RUN_PROCESSES  
BPM_RUN_STEPS  
BPM_ERRORS  
BPM_ERROR_ARGUMENTS  
BPM_RUN_ASSIGNEES  
BPM_RUN_ASSIGNEE_NOTES  
BPM_RUN_OBJECTS  
BPM_RUN_STEP_ACTION_RESULTS  
BPM_RUN_STEP_COND_OBJECTS  
BPM_RUN_STEP_COND_RESULTS  
BPM_RUN_STEP_TRANSITIONS  
BPM_RUN_THREADS
CAL_ACTION_ITEMS (OBJECT_TYPE = CAL_WORKFLOW)
CAL_ACTION_ITEM_ASSIGNEES