This content has been marked as final. Show 4 replies
There is a script named wfrmitt.sql available - use with caution1 person found this helpful
How can customizations be removed from a workflow? [ID 287369.1]
Oracle Applications Object Library SQL scripts [ID 108185.1]
Looks like there are two ways to delete a process viz.
1. Run wfrmitt.sql to completely remove the workflow item_type from the database then reload it. Not a preferred option, because existing workflow process in progress might get affected as the complete item is deleted. For e.g. in the above scenario even the process P1 will get deleted and if there is any workflow instance using process P1 in progress it will get affected.
2. You retrieve it using the Workflow Builder then delete it before saving it back into the database. This the same way described in my question above.
Not a convenient option, as it requires manual intervention. Using this procedure in production envirornments will be risky.
Is there any other way in which a process can be deleted?
Not that I am aware of - pl open an SR with Support to confirm1 person found this helpful
WFLOAD works pretty much the same as FNDLOAD, none of them are designed to remove data during upload mode so what you are seeing is proper. If you want to deactivate a process within the same item type you may flag it as not runnable.1 person found this helpful
Edited by: Alejandro Sosa on Jan 14, 2013 7:39 AM