My Oracle Support Banner

SQL Statements In Operation Guide Are Not Correct Anymore (Doc ID 2363811.1)

Last updated on MARCH 26, 2019

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

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
References


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