Supply Chain Cost Rollup - Print Report (Xml) Takes long time to run Performance (Doc ID 1359684.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Submit Supply Chain Cost Rollup - Print Report (XML) takes 11 hours to complete for one BOM item. Gather schema stats was run at 100% on a weekly basis.
Truncating tables resulted in no change.   This is just an XML report.  

The text version of this report runs quickly with no issues. Support suggested patch: 9962574.
File version = 120.15.12010000.3

Also the report shows error in the log file.

Error
---------
log file shows that the code
failure is in the BOM code - BOM_CSTRSCCR_XMLP_PKG.beforereport ;

oracle.apps.xdo.XDOException: !!Error : trigger 'beforeReportTrigger' returns status as 'false'
at oracle.apps.xdo.dataengine.XMLPGEN.executeTriggers(XMLPGEN.java:654)
at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:263)
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)




STEPS
1.  Submit Supply Chain Cost Rollup - Print Report

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