Auto Accept E2B Reports Ag Service Process is Taking More Than 10 Minutes To Complete the Execution

(Doc ID 1578809.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Argus Safety - Version 5.0.5.1 and later
Information in this document applies to any platform.
*** Checked for relevance: 02-Apr-2015 ***
***Checked for relevance on 23-JUN-2017***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms