R12 Workflow clean up
Database : 11.2.0.3.0
Oracle Applications : 12.1.3
Product/services we use: AP,AR,PA,CM,GL,service contract,WMS,OM,PO,isupplier,iexpense and iprocurement.
Dear All,
We are using standard & custom workflow for above mentioned product and would like to cleanup old notification which is consuming more database space, so I have below requirement
1. What are all notifications can be deleted and is there is standard program to do so?, especially for iexpense, iprocurement, ASBN, OE & PO closed notification
2. If there is no standard program can we delete using script? if yes script please?
3. Need to delete all orphan records too? any standard program or script please?