The Data Loader in ver7.11 for Task Indicators is extremely slow, 8 indicators to a standard task in 5 hrs.
Upon review, the code appears to be calling inappropriate common function, build hierarchy:The SQL Query that seems to be slowing the Task Indicator Dataloader is:SELECT c.Indicatoroi,c.Indicatoroi,c.Site_oiFROM ((MNT.ConditionIndicator c LEFT OUTER JOIN FND.Site s ON c.Site_oi=s.Siteoi) LEFT OUTER JOIN MNT.Asset a ON c.Asset_oi=a.Assetoi)WHERE EXISTS (select * from FND.Site_1000055304 where parent_oi=s.Siteoi and child_oi=81 ) AND EXISTS (select * from MNT.Asset_1000036528 where (parent_oi=76543 and child_oi=a.Assetoi) or (parent_oi=a.Assetoi and child_oi=76543) ) AND c.IndicatorNam='CTW PMT PREVENTIVE MAINTENANCE STATUS'
Repaired in release 7.12.2.
VSTS168828 - Task Indicator Dataloader is slow due to inappropriate, extra business logic. SR 7000932505