My Oracle Support Banner

Poor performance of PDP workers pulling data from MRP_AP3_SALES_ORDERS_V (Doc ID 2717333.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version of VCP integrated with 12.1.3 version of EBS, Data Collections in Production Instance

ACTUAL BEHAVIOR
---------------

While running target refresh data collections with sales order set to yes, the planning data pull workers are taking long time.
The workers are taking around 120 + mins.

Issue mainly caused by poor performance of pull of data from MRP_AP3_SALES_ORDERS_V


EXPECTED BEHAVIOR
-----------------------
Expect the PDP worker to complete in around 60 mins time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter the application.
2. Launch target refresh data collections with sales order set to yes.
3. See the above issue.


Cause

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
Symptoms
Cause
Solution
References


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