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

Last updated on JULY 13, 2023

Applies to:

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

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