My Oracle Support Banner

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 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,
  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


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.