Skip to Main Content

APEX

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!

How to dynamically update the DUE_ON time for a Wait activity in APEX Workflow?

sr opor4 days ago

I'm using the Workflow feature in Oracle APEX and have a Wait activity type configured to resume at a specific time. I can see the scheduled time reflected in the DUE_ON column of APEX_WORKFLOW_ACTIVITIES.
My question is: Is there a supported way to change or update the DUE_ON value after the workflow instance has already started?
For example, if the wait was originally set to resume tomorrow at 08:00, but a business rule requires it to be rescheduled to a different time — can we update that programmatically?

Things I've already considered:

Directly updating APEX_WORKFLOW_ACTIVITIES (which is likely a view and probably not updatable)
Looking for a built-in APEX API like APEX_WORKFLOW package that might have a reschedule procedure

Comments
Post Details
Added 4 days ago
4 comments
66 views