Planning Data Pull Is Long Running (Doc ID 1478644.1)

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

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