SQL Statements In Operation Guide Are Not Correct Anymore

(Doc ID 2363811.1)

Last updated on FEBRUARY 21, 2018

Applies to:

Oracle Health Insurance Claims Adjudication - Version 2.17.2.0.0 to 2.17.2.0.0 [Release 2.17]
Information in this document applies to any platform.

Goal

SQL statement in Operation guide is not correct anymore.

select taty.name tasktype
, round(avg(EXTRACT(DAY FROM(task.process_stop_datetimetask.
process_start_datetime) DAY TO SECOND)*86400 +
EXTRACT(HOUR FROM(task.process_stop_datetimetask.
process_start_datetime) DAY TO SECOND)*3600 +
EXTRACT(MINUTE FROM(task.process_stop_datetimetask.
process_start_datetime) DAY TO SECOND)*60 +
EXTRACT(SECOND FROM(task.process_stop_datetimetask.
process_start_datetime) DAY TO SECOND)),0)
avg_process_elapsed_time_ss
from ohi_tasks task
, ohi_task_types_tl taty
where task.taty_id = taty.id
and taty.language = 'en'
and task.process_stop_datetime is not null
and task.creation_date between trunc(sysdate - 1) and trunc(sysdate)
group by taty.name;
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms