3 Replies Latest reply on Oct 3, 2017 8:27 PM by VenkatMuthadi

    Reports output in RAW XML format

    Jegathees

      Dears,

       

      My environment is 12.1.3 application with 11.2.0.3 database.

       

      Reports like Create accounting generates raw XML output in the unreadable format. And getting the below message in OPP,

       

      [9/27/17 11:17:36 PM] [OPPServiceThread0] Post-processing request 85731646.

      [9/27/17 11:17:37 PM] [372857:RT85731646] Executing post-processing actions for request 85731646.

      [9/27/17 11:17:37 PM] [372857:RT85731646] Starting XML Publisher post-processing action.

      [9/27/17 11:17:37 PM] [372857:RT85731646]

      Template code: FAACCPB01

      Template app:  OFA

      Language:      en

      Territory:     US

      Output type:   PDF

      [9/27/17 11:17:37 PM] [372857:RT85731646] Output file was found but is zero sized - Deleted

      [9/27/17 11:17:37 PM] [UNEXPECTED] [372857:RT85731646] java.lang.NullPointerException

      at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:133)

      at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)

      at oracle.apps.xdo.common.log.DebugUtil.logFile(DebugUtil.java:236)

      at oracle.apps.xdo.common.log.Logger.logFile(Logger.java:590)

      at oracle.apps.xdo.template.FOProcessor.logFile(FOProcessor.java:1809)

      at oracle.apps.xdo.template.FOProcessor.getXSLInput(FOProcessor.java:1168)

      at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:881)

      at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5978)

      at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3470)

      at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3559)

      at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:311)

      at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:184)

       

       

      [9/27/17 11:17:37 PM] [372857:RT85731646] Completed post-processing actions for request 85731646.

       

       

       

      I have tried increasing Heap size and tmp location check but no luck. Please help me out on this.

       

      Thanks.

        • 1. Re: Reports output in RAW XML format
          Dhanya-Oracle

          Hi,

           

          If the issue is specific to one report, check if the template is attached to the program in xml publisher responsibililty

          When submitting the program from Submit request window, is the layout picked up correctly and check the output is correctly displayed under layout in the same form.

          Try to do a preview from xml publisher responsibility using the same xml data file and template.

          Check if the xml file geenrated is openable from browser.

           

          Regards,

          Dhanya

          • 2. Re: Reports output in RAW XML format
            Jegathees

            Hi Dhanya,

             

            Issue is with all reports with XML output. Template correctly attached with reports and in browser also it's showing raw XML file only.

             

            I have recently applied RPC 5 patches since then I'm facing this issue.

             

            Thanks.

            • 3. Re: Reports output in RAW XML format
              VenkatMuthadi

              Hi,

               

              What are your OPP Memory values and temp space.

               

              1) Ensure that OPP memory is set to 2GB

              2) Temp has atleast 5-10G of free space. Temp location can be obtained from "Xml Publisher" responsibility -> Administration -> path

               

              Regards,

              Venkat