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!

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
643 views