Continuous Collection Long Running After upgrade to from

(Doc ID 1937333.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version and later
Information in this document applies to any platform.


VCP Patch 17350769

11.5.10 EBS source with Collections RUP #36 - 12731023 and 9117862

Continuous Collections is taking much longer after upgrade of APS destination from 11.5.10 to

The Continous Collection is long running (more or less 3 hours, compared to the previous timing that was more or less 1 hr).

The Refresh Collection Snapshot is running for more or less 1 hour and we noticed that Collection is taking time while performing select * from the MRP_AP views.

We noticed that most of the long running is related to the following views:


Run Continuous collections


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