Duplicate Rows In AAI_WF_PROCESS_ENGINE_ACT_QUE
(Doc ID 2723805.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and laterInformation 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 |