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?
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
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:
CAL_ACTION_ITEMS (OBJECT_TYPE = CAL_WORKFLOW)