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

Last updated on JULY 13, 2023

Applies to:

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

Goal

Oracle Life Sciences 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.

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

Applies to:

Goal

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!