Planning Data Pull Is Long Running (Doc ID 1478644.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 02-JUN-2014***

Symptoms

11.5.10 in Production and Test


PROBLEM
-------------
Planning Data pull is running long in Planning instance.

MSCPDP module: Planning Data Pull

Timeout error. 

User-Defined Exception

CREATE INDEX BOM_INV_COMPS_SN_N2 ON BOM_INV_COMPS_SN (Bill_Sequence_ID) 
 TABLESPACE BOMX 
 
 call     count       cpu    elapsed       disk      query    current         rows 
------- ------  -------- ---------- ---------- ---------- ----------  ---------- 
Parse        1      0.00       0.01          0          1          0             0 
Execute      1    310.59     759.87    1046699     854229     163672           0 
Fetch        0      0.00       0.00          0          0          0             0 
------- ------  -------- ---------- ---------- ---------- ----------   --------- 
total        2    310.59     759.88    1046699     854230     163672 

 

STEPS
--------
Launch Collections in APS instance

BUSINESS IMPACT
----------------------
Cannot complete a collection.

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