My Oracle Support Banner

Duplicate Rows In AAI_WF_PROCESS_ENGINE_ACT_QUE (Doc ID 2723805.1)

Last updated on NOVEMBER 04, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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