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.

Oracle APEX 24.1 Renewed task is not getting associated with Workflow

Karthik DPHJan 16 2025

Hi

36605935 - HUMAN TASKS STARTED FROM A WORKFLOW LOSE WORKFLOW DETAILS WHEN RENEWED

Do we have any alternative solutions?

Can we programmatically extend the due time using the APEX_HUMAN_TASK package?

Initially, I set the due time to 2 hours. Using the Before Expire event, is it possible to assign a new potential user and update the due date through the Business Administrator session?

apex_session.create_session(p_app_id => :APP_ID,
p_page_id => null,
p_username => 'PAT');

BEGIN

apex_human_task.add_task_potential_owner(
p_task_id => :APEX$TASK_ID,
p_potential_owner => get_approver(:APEX$TASK_PK,1)
);

apex_human_task.set_task_due(
p_task_id => :APEX$TASK_ID,
p_due_date => sysdate+20
);

END;

I was able to change the potential user, but I could not change the DUE date APEX.TASK.SET_DUE_DATE_NOT_AUTHORIZED Contact your application administrator.

Comments
Post Details
Added on Jan 16 2025
6 comments
220 views