Auto Accept E2B Reports Ag Service Process is Taking More Than 10 Minutes To Complete the Execution
(Doc ID 1578809.1)
Last updated on APRIL 22, 2021
Applies to:Oracle Argus Safety - Version 22.214.171.124 and later
Information in this document applies to any platform.
*** Checked for relevance: 02-Apr-2015 ***
***Checked for relevance on 23-JUN-2017***
***Checked for relevance on 27-SEP-2020***
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,
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
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