Auto Accept E2B Reports Ag Service Process is Taking More Than 10 Minutes To Complete the Execution
(Doc ID 1578809.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 5.0.5.1 and laterInformation in this document applies to any platform.
***Checked for relevance on 27-SEP-2020***
Symptoms
AUTO ACCEPT E2B REPORTS AG Service Process is taking more than 10 minutes when running the package call "gss_procs.f_populate_esmautoaccept" in large databases
Steps to Repeat:
1. Configure AUTO ACCEPT E2B REPORTS AG Service Process and turn on the SQLTimes on the AG Service box
2. Import 10 E2B Reports
3. Observe that the following SQL that is part of "gss_procs.f_populate_esmautoaccept" package taking more than 10 minutes to complete
SELECT NVL (s.case_xref, :"SYS_B_0") case_xref, s.report_id, s.e2b_type,
cm.case_num, s.safetyreportid
FROM safetyreport s, case_master cm
WHERE s.case_xref = cm.case_id(+) AND s.locked_user_id = :"SYS_B_1"
ORDER BY s.report_id
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |