My Oracle Support Banner

How To Find Start And End Time Of Any Behaviour Detection(Scenario Related) Task Of Batch (Doc ID 2852366.1)

Last updated on MARCH 05, 2022

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Goal

How to find Start and end time of any behavior detection(Scenario related) task of batch. Please provide the tables. As client observed below query not listing behavior detection(Scenario related) tasks

SELECT
V_BATCH_RUN_ID,
V_TASK_ID,to_number(SUBSTR(v_task_id,5,7)) Task_order,
TO_CHAR(Min(TIMESTAMP),'DD-MON-YYYY HH24:MI:SS') Start_time,
TO_CHAR(MAX(TIMESTAMP),'DD-MON-YYYY HH24:MI:SS') End_time,
round(((nvl(MAX(TIMESTAMP),sysdate)-Min(TIMESTAMP))*24*60)) Elapsed_Time_Mins,
V_TASK_STATUS
FROM PRO_OFSAACONF.BATCH_MONITOR
WHERE V_BATCH_RUN_ID like '%Batch run id%' and V_TASK_ID!='NOTASKID'
GROUP BY V_BATCH_RUN_ID,V_TASK_ID,V_TASK_STATUS
ORDER BY task_order asc;

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.