EMDR : Issue With Performance For Query Within The Package EMDR_MAPPING_UTL.GET_G8ADVERSEEVENTTERM
(Doc ID 2453972.1)
Last updated on FEBRUARY 25, 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