Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cancel Approval Pending workflow from PL SQL API

OptimuskckAug 11 2017 — edited Aug 16 2017

I have found an API that user can cancel Workflow

wf_notification.CANCEL(nid in number, cancel_comment in varchar2 default null);

When i run that statement i was able to change the workflow's status to 'CANCELED' in WF_NOTIFICATIONS table. But workflow still appear to approve for the user . it does not get canceled and error thrown when i am trying to approve or reject from user

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "APPS.WF_NOTIFICATION", line 4873 ORA-06512: at line 1

Is there are any other way to cancel a workflow which is pending approval AND / OR what am i doing wrong here. Any insight would be really appreciated .

Thanks

This post has been answered by 2921881 on Aug 11 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2017

Added on Aug 11 2017

#database-key-features, #workflow

1 comment

2,892 views