Continuous Collection Long Running After upgrade to 18.104.22.168.1 from 22.214.171.124
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 126.96.36.199 and later
Information in this document applies to any platform.
VCP 188.8.131.52.1 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 184.108.40.206.1
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