My Oracle Support Banner

MSCPDPW MRP_AP_CUSTOMER_CONTACTS_V Performance Problem (Doc ID 1487136.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


When attempting to run Data Collection the Planning Data Pull got the following error.


25-JUL 04:36:46 : Planning Data Pull Worker( Request_ID=1607163) is submitted.
25-JUL 04:36:46 : Planning Data Pull Worker( Request_ID=1607164) is submitted.
25-JUL 07:37:12 : Timeout error.
25-JUL 07:37:12 : User-Defined Exception

Customer identified the following Planning Data Pull SQL as the long running SQL:

insert into msc_st_partner_contacts
, display_name
, email
, fax
, partner_id
, partner_site_id
, partner_type
, enabled_flag
, deleted_flag
, refresh_id
, sr_instance_id)
, x.display_name
, x.fax
, x.partner_id
, x.partner_site_id
, 2
, enabled_flag
, 2
, :v_refresh_id
, :v_instance_id
from mrp_ap_customer_contacts_v@dest_to_src_dblink x


This means that the performance of MRP_AP_CUSTOMER_CONTACTS_V on the EBS Source instance is causing the perfomance problem.

1. Run Data 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
 Fixed by Bug #
 Fixed File
 1st Fixed File Version
 1st shipped in VCP Cum Patch
 One Off Patch

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