To run the request set:The workflow cleanup process enables you to remove workflow processes that are left running if a system crashes or a user ID is disabled or removed. The process cleans up temporary tables by removing redundant transaction information. You can specify which transactions are queried by the process by setting the Transaction Status parameter.
You run the cleanup process by running the concurrent program Complete Defunct HR Workflow Processes from the Submit Request Set window.
Before you run the cleanup process, you must define a request set that runs the Purge Obsolete Workflow Runtime Data (FNDWFPR) concurrent program before the Complete Defunct HR Workflow Resources (HRWFDFCT) concurrent program.
Note: From SSHR 4.1, the Complete Defunct Workflow Processes concurrent process is registered under Oracle Human Resources instead of Oracle Self-Service Web Applications. If you previously scheduled this concurrent process to run when still registered under Oracle Self-Service Web Applications, you must cancel the process and resubmit it using the new Complete Defunct HR Workflow Processes registered under Oracle Human Resources.
To run the request set:In the Request Set field, enter the name of your request set.
Place your cursor on the Parameters field in the row for the Purge Obsolete Workflow Runtime Data process to open the Parameters window.
Select the item type for which you want to remove obsolete workflow runtime data. If you leave the field blank, the process will purge obsolete data for all item types.
If applicable, enter an item key.
Enter the number of days for which you want to run the process. For example, if you want to purge obsolete data for the last 7 days, enter 7.
Select the persistence type of the data to be purged (Temporary or Permanent).
Choose OK to close the Parameters window.
Place your cursor on the Parameters field in the row for the Complete Defunct HR Workflow Processes process to open the Parameters window.
Select the item type to be included in the process.
Enter the number of days for which you want to run the process. For example, if you want to run the cleanup process for the last 7 days, enter 7.
Select the transaction statuses to be queried in the program. The permitted values for the transaction status parameter are as follows:
Transaction Status Values
| Parameter Value | Description |
|---|---|
| ALL | All transaction statuses are queried in the program. |
| C | Transaction returned for correction (in modules with SSHR V4.x and earlier) |
| RO | Transactions returned to approver for correction |
| ROS | Transactions returned to approver for correction and saved for later |
| RI | Transactions returned to initiator for correction |
| RIS | Transactions returned to initiator for correction and saved for later |
| D | Deleted transactions |
| E | Transactions with errors |
| N | Transactions initiated but not submitted for approval |
| S | Transactions saved for later |
| W | Transactions in progress |
Choose the Submit button.