This discussion is archived
5 Replies Latest reply: Jul 3, 2012 12:05 AM by vlsn RSS

XML publisher report not generating output for huge XML files

919342 Newbie
Currently Being Moderated
Changed Depreciation Projections Report output type to XML.
Defined a Data Definition and a new Data Template (RTF) for this report.
Ran the Depreciation Projection Report to generate the XML output.
Ran the XML Report Publisher report to generate teh PDF/Excel output of the above report.

Output generated for smaller XML files. When XML size is big, the program is running for hours without generating the output.

Teh RTF template is basically a matrix report in which the number of columns in the report is based on the number of periods the report is run for.

The same is not working in the Desktop version also. The system is hanging when i try to view the preview pdf.

The XML file size is approximately 33 MB.

Please let me know if there is any way we can increase the memory size to see the output.

Thanks,
Ram.
  • 1. Re: XML publisher report not generating output for huge XML files
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl post details of OS, database and EBS versions. Are you seeing any errors or messages in the concurrent log or the OPP log ?

    Pl ensure that there is a TEMP directory defined for XML Publisher and that the directory has enough space

    How to set the Temp Directory for BI Publisher ? [ID 1166024.1]

    Pl also review this MOS Doc and set indicated parameters appropriately
         
    R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues [ID 1410160.1]     

    HTH
    Srini
  • 2. Re: XML publisher report not generating output for huge XML files
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please check the OPP log file for any errors. Also, please post the contents of the concurrent request log file here.
    Please let me know if there is any way we can increase the memory size to see the output.
    Out Of Memory Error When Running XML Publisher Template Re-Generator Concurrent Program [ID 788935.1]
    XML Publisher Data Template Request XDODTEXE Fails with Java.Lang.OutOfMemoryError [ID 390968.1]
    XML Publisher Report Issues, Recommendations and Errors [ID 862644.1]
    Output Post Processor (OPP) Log Contains Error "java.lang.OutOfMemoryError" [ID 1266368.1]
    About Oracle XML Publisher Release 5.6.3 [ID 422508.1]
    Output Post Processor (OPP) Log Contains Error "java.lang.OutOfMemoryError: Java heap space" [ID 1268217.1]
    Overview of Available Patches for Oracle XML Publisher embedded in the Oracle E-Business Suite [ID 1138602.1]
    How to Configure the Account Analysis Report in Release 12 for Large Reports [ID 737311.1]

    Thanks,
    Hussein
  • 3. Re: XML publisher report not generating output for huge XML files
    919342 Newbie
    Currently Being Moderated
    Hi,

    Thanks for the replies.
    Actually, there doesn't seem to be any error in the concurrent program log file or the Output Post Processor log file.
    The concurrent program is still running for days without ending.

    Another observation is, I am not able to see the PDF/EXCEL preview of the XML file even using the XML Publisher Desktop version.

    Please suggest me on what could be the issue.

    Thanks,
    Ram.
  • 4. Re: XML publisher report not generating output for huge XML files
    932004 Newbie
    Currently Being Moderated
    similar issue ..i have come across in our environment...
    bouncing OPP manager will fix this issue.

    as a permanent fix , you need to check your current heap size and try to increase it upto 2gb.
    follow below instruction to increase the heap size.

    1. Determine what the heap size per OPP process is currently:

    select DEVELOPER_PARAMETERS from FND_CP_SERVICES
    where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
    where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

    2. The default should be:
    J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m

    3. Increase the Heap Space per Process to 1024:
    update FND_CP_SERVICES
    set DEVELOPER_PARAMETERS =
    'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
    where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
    where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

    4. Bounce the concurrent managers server.



    thanks,
    Nanda

    Edited by: 929001 on 19/04/2012 23:24
  • 5. Re: XML publisher report not generating output for huge XML files
    vlsn Newbie
    Currently Being Moderated
    HI,

    Is there any chance of code change to fix this issue instead of increasing the Heap size.Please tell me the solution.

    Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points