How to Rewind many 'errored' workflow process in batch.
This is the situation: EBS 11.5.10.2, with ATG.H RUP6 installed. We have many (over 200) OAM_BE workflow items errored out; but we identified that rewinding them fixes the problem. (we tested it with three of them). But the user is worried about carpal tunnel syndrome and wishes to know if there is a way to "mass rewind" these workflow processes, say, from a sql batch file.
I would guess that this could be achieved by calling the workflow api, but I would like to know if anybody else in the Oracle Universe has faced this problem.
Thanks,