Skip to Main Content
Feature Request FR-4302
Product Area Workflow
Status CLOSED

2 Voters

Implement a Concurrent Managers

marcelo osorio k Public · Mar 1 2025

Idea Summary
Concurrent manager implementation. A queue managed by ia or manually. In order to send long processes. 

Use Case
The big company processes execution need to have logs, traceability and process summary. The key  processes or big processes need to be exposed to the users giving a execution log and traceability information.

Preferred Solution (Optional)

Create a new api with the stored procedure name , parameters, priority, username. Create new views in order to see the concurrent id, start execution, end execution , status, executed by.

This is a great idea! You can already achieve this in APEX today with a slightly different approach.

Comments

Comments

  • ralf.mueller APEX Team OP 12 days ago

    Hi @marcelo osorio k , 

    we do not understand what the concrete ask is here and how that is related to APEX Workflow. In 24.2, one can model a workflow that implements the long running job and then call this workflow from another via ‘Invoke Workflow’ activity. For Workflows you have detailed audit and trace information logged that is also queryable as we expose public SQL views on the WF audit log.

    Regards,

    Ralf

  • marcelo osorio k OP 11 days ago

    Hi Ralf,

    Is not related to any workflow feature. It is a new feature it self. If you have been worked with oracle applications or oracle fusion, you probably has seen a concurrent manager process. A feature which allow execute processes in the background, execute batch processing, and other tasks that need to run asynchronously from the main application. The concurrent manager picks up these jobs from the request queue and processes them. It runs them based on predefined scheduling rules, priorities, and available resources. Once completed, the results are stored, and users can review the output/logs, and just here is the key feature, focused on the final users. 

    Regards,

    Marcelo

  • marcelo osorio k OP 11 days ago

    Regarding the workflow. Workflow could submit a batch process using the new API.

    Regards,

    Marcelo

  • gberp OP 6 days ago (edited 6 days ago)

    Not workflow, not workflow, not workflow, important repeat three times.  

     This is the concurrency manager, it has nothing to do with workflow, please don't bull****.  Very important function.  Supported.

  • ralf.mueller APEX Team OP 6 days ago

    Hi @marcelo osorio k ,

    I know SOA Suite and Fusion. We had ESS there to schedule background work. In Oracle Database one could use DBMS_SCHEDULER to do this, it is quite powerful and easy to integrate with APEX Workflow, maybe I am going to blog about it.

    If its not in the context of Workflow, you can use APEX background processes, see documentation links below

    Regards,

    Ralf

  • ralf.mueller APEX Team OP 6 days ago

    Here's the documentation for APEX background processes and DBMS_SCHEDULER

    • https://docs.oracle.com/en/database/oracle/apex/24.1/htmdb/understanding-background-page-processing.html
    • https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SCHEDULER.html