Continuous Collection Long Running After upgrade to 184.108.40.206.1 from 220.127.116.11
(Doc ID 1937333.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 18.104.22.168 and later
Information in this document applies to any platform.
VCP 22.214.171.124.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 126.96.36.199.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
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