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 FEBRUARY 14, 2019

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.