Bookmark and Share Subscribe You may face visibility problem if http://docs.google.com is blocked on your network

Wednesday, May 18, 2016

How to cancel / terminate / abort workflow in Oracle R12?

One way is to do it using API WF_ENGINE.ABORTPROCESS by wrtting a simple script like below…


BEGIN
  WF_ENGINE.ABORTPROCESS ('GLBATCH', ' 2949213*847');  
-- wf_engine.ABORTPROCESS ('Type Internal Name', 'Item Key');
END;


COMMIT;


Another way which I think is more appropriate than API is to do it from front end… to perform below steps you need to have workflow admin access.


Step 1: Query the workflow and click on ‘Activity History’ button
cid:image002.jpg@01D1B117.666452B0


Step 2: Click on ‘Cancel Workflow’ button
cid:image010.jpg@01D1B117.666452B0
Step 3: Click on ‘Apply’ button
cid:image011.jpg@01D1B117.666452B0


Step 4: Re-query workflow, verify if workflow is cancelled
cid:image013.jpg@01D1B117.666452B0
Step 5: Open ‘Activity History’ and verify if open notification is closed / complete
cid:image015.jpg@01D1B117.666452B0

Please add your valuable feedback / comments

Declaimer:

This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy