My Oracle Support Banner

CIOMS II Line Listing Against DLP Data is Taking More Than 3 Days to Complete - Why ? (Doc ID 2744092.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Argus Safety - Version 8.2.1 and later
Information in this document applies to any platform.

Goal

Reports such as CIOMS II Line Listing when run on DLP are taking a long time to complete (Native Argus runs are fine).

There is a known Bug 25421664 logged for this per Note 2435993.1 - Aggregate Reports e.g. CDA, Case Listing and CIOMS II LL Reports Are Slow to Complete.

However solution did not resolve in this case, since did not observe any issues with PKG_DLP.P_GET_CASE_REVISIONS_FOR_DATES function. This function completed in few seconds.

However, the report did not appear to make any progress after updating the user_case table (Confirmed by running Argus SQL*Times logging)

Solution

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
Goal
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.