Delete Vacation Rules Using Script
You may want to periodically delete unneeded vacation rule data from your system to increase performance. A new script named wfvcrdlt.sql lets you delete end-dated vacation rules for a user all at once instead of needing to delete the rules individually through the UI. You can optionally choose to delete only vacation rules for that user of a particular item type or only vacation rules for that user whose effective period ended before a particular date.
Steps to enable and configure
You don't need to do anything to enable this feature.
Key resources
- Wfvcrdlt.sql, Oracle Workflow Administrator's Guide
- Defining Vacation Rules for Users, Oracle Workflow Administrator's Guide