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 SEPTEMBER 18, 2019

Applies to:

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


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.



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

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