oracle-apexworkflow

same workflow works on OCI but fails onprem

I am trying the most basic wf possible.. no decision point, no wait, no api calls.

just

start > action > end

in action step, I run insert into wfTest values ('abc');

then I have a button on Page 1 and I have a process for page submit.

Type: Workflow 
Definition: my_test_workflow 
When button pressed: my_button

I got this both on my cloud instance (24.2.0) and on-prem (24.1.0)

if I click the button on cloud, it inserts one line. if I click the same button on-prem, nothing happens.

What would be your advise to check first?

Solution

  • I’ve identified the issue. It turns out that the Oracle Workflow Engine requires DBMS_SCHEDULER to be enabled.

    If it’s not, jobs may be created but won’t progress, understandably, since the scheduler is responsible for executing them.