Duplicate Rows In AAI_WF_PROCESS_ENGINE_ACT_QUE (Doc ID 2723805.1)

Last updated on MAY 22, 2023

Applies to:

Goal

FR Workflow for some case process, it will create a duplicate row as waiting status, which show as waiting status under V_Status column in AAI_WF_PROCESS_ENGINE_ACT_QUE table.

This issue may occur due to Out of memory or batch interrupted situation

 Executethe below query in config schema to know the multiple waiting status.

SELECT
    v_process_instance_id,
    v_status,
    COUNT(*)
FROM
    aai_wf_process_engine_act_que
WHERE
    v_status IN (
        'WAITING',
        'WAITINGFORRESTART'
    )
GROUP BY
    v_process_instance_id,
    v_status
HAVING
    COUNT(*) > 1;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.