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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Creating Workflow Task Programmatically

Jacob HoferDec 17 2024

I am creating tasks using APEX_HUMAN_TASK.CREATE_TASK.

I can successfully create the tasks, but I want to associate the tasks with an active workflow, and am unsure how to do so.

The tasks are being created from a custom plugin that is part of the workflow, via the execution function:

FUNCTION f_create_tasks (
    p_process IN APEX_PLUGIN.t_process,
    p_plugin IN APEX_PLUGIN.t_plugin 
) RETURN APEX_PLUGIN.t_process_exec_result IS
BEGIN
	-- The tasks are to be created here
END;

I am not sure if this is even possible, but I want to be able to easily keep track of associated tasks, with the idea being that all tasks must be completed (but in any order) for the plugin to be completed and for the workflow to continue. I would prefer to not create an extra table, especially since the apex_tasks table already has a workflow_id column I could use to group the tasks together.

Thanks!

Comments
Post Details
Added on Dec 17 2024
9 comments
285 views