My Oracle Support Banner

EMDR : Issue With Performance For Query Within The Package EMDR_MAPPING_UTL.GET_G8ADVERSEEVENTTERM (Doc ID 2453972.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Argus Safety - Version 8.1.2 and later
Information in this document applies to any platform.

Goal

Oracle Argus Safety Version - 8.1.2

Performance issue was noted within the package "emdr_mapping_utl.GET_G8ADVERSEEVENTTERM".

In the below query , there is a join missing on case_event_assess to check for case_id.

Potentially this could impact the performance of the query which in turn impacts the eMDR report generation.



 

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.