Skip to Main Content
Feature Request FR-3918
Product Area Workflow
Status DELIVERED

2 Voters

Workflow Admin Tool to interact with a running process

jfourie Public
· Jul 19 2024

Idea Summary
We have been using Oracle Workflow for 24 years. We have to date not found any other Workflow tool in the Oracle space that can do the same job. Oracle Workflow standalone was discontinued in 2003. But we are still using it. We have Apex as our user interface (used to be Oracle Forms) and Oracle Workflow as our Workflow engine. We have looked at Apex Workflow and Flows for Apex but both have the same limitations. There are not proper tools to manage running processes like we have in Oracle Workflow. In Oracle workflow we are able to change any attribute / variable and then expedite a proses by retrying a node or telling it to skip a node. We have many long running processes that run for months and sometimes for whatever reason data between systems may go out of sync. That data is used to decide what transition to take when we get to a decision node. So, the process goes down the wrong path. We then need to be able to fix the data and then force the workflow down the path it should have taken.   

Here you can see I can select a Node and then click on Expedite. Then I have the option to retry that node that will fire the code again or I can select the route / transition it should take when retrying. In this case I can select “Not Level 70” and it will take the new route as it took the “Level 70” the first time as the data was wrong when the process got to that point.

Here you can see I can update any attribute / variable of the running process if I click on the attribute button to a new value of the running instance.

Use Case
The admin tool is needed to fix long running processes that took wrong paths / transitions because of wrong data at that point in time. We need a tool similar to the Oracle Workflow Monitor that gives an administrator the ability to change the path it took and also any runtime variables set for that instance of the process.

This has been delivered in Oracle APEX 24.2!

Comments

Comments

  • ralf.mueller APEX Team OP 12 months ago

    Hi @jfourie , we are very well aware of the power of Oracle Workflow and worked on and with Oracle Workflow prior to starting APEX Workflow. We understand your use case and are working off the backlog of planned features. As of today, a Business Admin of an APEX Workflow can suspend a running workflow instance, modify Workflow Variable(s) and then resume the Workflow. What we have not yet implemented is that you can resume the WF at a different activity but it is on our roadmap. 

    I am happy to discuss this with you as we'd like to make existing Oracle Workflow customers happy and gradually transition to APEX Workflow. Feel free to contact me at ralf.mueller@oracle.com

    Best Regards,

    Ralf