Find OPP Error and Resolve XML Report Warnning

How to Resolved Error Caused by: java.lang.OutOfMemoryError: Java heap space

SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name
  FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp
 WHERE fcpp.processor_id = fcp.concurrent_process_id
   AND fcpp.action_type = 6
   AND fcpp.concurrent_request_id = &request_id;






To investigate on XML issues or other publishing problems, often the OPP logfile is needed.
OPP stands for Output Post Processor. Below are the steps to find log file

1. Login to the application as SYSADMIN

2. Responsibility: System Administrator

3. Function: Concurrent --> Manager --> Administration

4. Select the Output Post Processor

5. Click on the Processes button

6. Select the Concurrent Process which was active during the time that the request ran

7. Click on the Manager Log button to open the Output Post Processor log file






/*

[5/18/16 6:55:24 PM] [252991:RT4384126] Output file was found but is zero sized - Deleted

[5/18/16 6:55:24 PM] [UNEXPECTED] [252991:RT4384126] java.lang.reflect.InvocationTargetException

    at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at oracle.apps.xdo.common.xml.XSLT10gR1.invokeParse(Unknown Source)
    at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
    at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
    at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
    at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(Unknown Source)
    at oracle.apps.xdo.template.FOProcessor.createFO(Unknown Source)
    at oracle.apps.xdo.template.FOProcessor.generate(Unknown Source)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5984)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3475)
    at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3564)
    at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311)
    at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:185)

Caused by: java.lang.OutOfMemoryError: Java heap space

    at oracle.xdo.parser.v2.XMLDocument.xdkIncCurrentId(XMLDocument.java:3020)
    at oracle.xdo.parser.v2.XMLNode.xdkInit(XMLNode.java:2758)
    at oracle.xdo.parser.v2.XMLNode.(XMLNode.java:423)
    at oracle.xdo.parser.v2.CharData.(CharData.java:118)
    at oracle.xdo.parser.v2.XMLText.(XMLText.java:168)
    at oracle.xdo.parser.v2.XMLDocument.createNodeFromType(XMLDocument.java:2869)
    at oracle.xdo.parser.v2.XMLDocument.createNodeFromType(XMLDocument.java:3000)
    at oracle.xdo.parser.v2.XMLDocument.createTextNode(XMLDocument.java:735)
    at oracle.xdo.parser.v2.DocumentBuilder.characters(DocumentBuilder.java:553)
    at oracle.xdo.parser.v2.NonValidatingParser.reportCharacters(NonValidatingParser.java:1680)
    at oracle.xdo.parser.v2.NonValidatingParser.parseText(NonValidatingParser.java:1391)
    at oracle.xdo.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1268)
    at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:338)
    at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:285)
    at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:289)
*/



select developer_parameters from  fnd_cp_services
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = 'FNDCPOPP');

You simply increase the value.


   UPDATE fnd_cp_services SET developer_parameters =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx4096m'
WHERE service_id = (SELECT manager_type
FROM fnd_concurrent_queues
WHERE concurrent_queue_name = 'FNDCPOPP');

Commit;

Bounce the application and  retest.