Continuous Collection Long Running After upgrade to 12.1.3.9.1 from 11.5.10.2 (Doc ID 1937333.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

VCP 12.1.3.9.1 Patch 17350769


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

PROBLEM
-------------
Continuous Collections is taking much longer after upgrade of APS destination from 11.5.10 to 12.1.3.9.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:


MRP_AP_ITEM_CATEGORIES_V
MRP_AP_SYSTEM_ITEMS_V
MRP_AP1_SALES_ORDERS_V
MRP_AP_PO_RCV_SUPPLY_V

STEPS
--------
Run Continuous collections


Cause

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