SQL Script to Delete Workflow Item Type definition and all its related data

By | July 29, 2014

To save a modified workflow we can either do it from workflow builder or WFLOAD but to a remove a workflow or to delete a workflow definition completely we dont have any standard way to do it.

wfrmitt.sql deletes all data in all Oracle Workflow design time and runtime tables for a particular item type. This script prompts you for an item type from a list of valid item types.

Use the script as follows:

sqlplus < apps /apps pwd > @$FND_TOP/SQL/wfrmitt

Warning: This script deletes ALL workflow data for a specified item type and this cannot be undone

Source: http://docs.oracle.com/cd/B14117_01/workflow.101/b10283/admsql26.htm#wfrmitt

WOW! Did you like this post? We'll send more interesting posts like SQL Script to Delete Workflow Item Type definition and all its related data to you!
Enter your Email Address: