5 Replies Latest reply: Sep 5, 2012 2:00 PM by Hussein Sawwan-Oracle RSS

    problem with xml report output

    959801
      Hi all,
      i’m using R12,i developed a xml report when i submit it in concurrent prmg it ends with a warning, with no output.
      below is the log which show same error for all xml reports, pls suggest..
      ---------------------------------------------------------------------------
      Application Object Library: Version : 12.0.0

      Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

      FNDSCURS module: Active Users
      ---------------------------------------------------------------------------

      Current system time is 03-SEP-2012 21:20:26

      ---------------------------------------------------------------------------


      +-----------------------------
      | Starting concurrent program execution...
      +-----------------------------


      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
      American_America.WE8MSWIN1252

      '.,'

      LOG :
      Report: D:\oracle\VIS\apps\apps_st\appl\fnd\12.0.0\reports\US\FNDSCURS.rdf
      Logged onto server:
      Username:



      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


      ---------------------------------------------------------------------------
      Executing request completion options...


      Output is not being printed because:
      The print option has been disabled for this report.

      ------------- 1) PUBLISH -------------
      Beginning post-processing of request 5823782 on node MURLI at 03-SEP-2012 21:20:33.
      Post-processing of request 5823782 failed at 03-SEP-2012 21:20:33 with the error message:
      One or more post-processing actions failed. Consult the OPP service log for details.
      --------------------------------------

      ------------- 2) PRINT   -------------
      --------------------------------------


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 03-SEP-2012 21:20:33

      ---------------------------------------------------------------------------

      Edited by: 956798 on Sep 4, 2012 3:45 AM

      Edited by: 956798 on Sep 4, 2012 3:45 AM
        • 1. Re: problem with xml report output
          Srini Chavali-Oracle
          >
          ...
          Post-processing of request 5823782 failed at 03-SEP-2012 21:20:33 with the error message:
          One or more post-processing actions failed. Consult the OPP service log for details.
          ...
          >

          Pl check the OPP (Output Post Processor) log file - the error message should be there. The OPP log will be in $APPLCSF/$APPLLOG directory and will be named FNDOPP99999.txt where 99999 is a 5-digit number

          Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite [ID 364547.1]

          Pl also review this tutorial and ensure that you have completed all of the required steps

          http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/xmlp_ebiz/index.html

          HTH
          Srini
          • 2. Re: problem with xml report output
            Hussein Sawwan-Oracle
            Beginning post-processing of request 5823782 on node MURLI at 03-SEP-2012 21:20:33.
            Post-processing of request 5823782 failed at 03-SEP-2012 21:20:33 with the error message:
            One or more post-processing actions failed. Consult the OPP service log for details.
            Please check the OPP log file for details about the error -- R12: Troubleshooting Known XML Publisher and E-Business Suite (EBS) Integration Issues [ID 1410160.1]

            Thanks,
            Hussein
            • 3. Re: problem with xml report output
              959801
              hi,

              could u pls help me to find the error in the below opp log file and how to fix it


              [9/4/12 9:17:52 PM] [main] Starting GSF service with concurrent process id = 2056209.
              [9/4/12 9:17:52 PM] [main] Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
              [9/4/12 9:17:52 PM] [Thread-19] Service thread starting up.
              [9/4/12 9:17:52 PM] [Thread-20] Service thread starting up.
              [9/4/12 9:54:41 PM] [OPPServiceThread0] Post-processing request 5824776.
              [9/4/12 9:54:41 PM] [2056209:RT5824776] Executing post-processing actions for request 5824776.
              [9/4/12 9:54:41 PM] [2056209:RT5824776] Starting XML Publisher post-processing action.
              [9/4/12 9:54:41 PM] [2056209:RT5824776]
              Template code: APXINLST
              Template app: SQLAP
              Language: en
              Territory: US
              Output type: RTF
              [090412_095442203][][EXCEPTION] [DEBUG] ------- Preferences defined PreferenceStore -------
              [090412_095442203][][EXCEPTION] [DEBUG] ------- Environment variables stored in EnvironmentStore -------
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.LOW]:[-1]
              [090412_095442203][][EXCEPTION] [DEBUG] [SECURITY_GROUP_ID]:[0]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_INTERVAL]:[300]
              [090412_095442203][][EXCEPTION] [DEBUG] [NLS_CHARACTERSET]:[AL32UTF8]
              [090412_095442203][][EXCEPTION] [DEBUG] [RESP_APPL_ID]:[-1]
              [090412_095442203][][EXCEPTION] [DEBUG] [NLS_LANGUAGE]:[AMERICAN]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
              [090412_095442203][][EXCEPTION] [DEBUG] [NLS_NUMERIC_CHARACTERS]:[.,]
              [090412_095442203][][EXCEPTION] [DEBUG] [APPS_JDBC_URL]:[jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=murli.oracle.com)(PORT=1521)))(CONNECT_DATA=(SID=VIS)))]
              [090412_095442203][][EXCEPTION] [DEBUG] [RESP_ID]:[-1]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_MAX_JDBC_CONNECTIONS]:[500]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_USABLE_CHECK]:[false]
              [090412_095442203][][EXCEPTION] [DEBUG] [USER_ID]:[-1]
              [090412_095442203][][EXCEPTION] [DEBUG] [NLS_TERRITORY]:[AMERICA]
              [090412_095442203][][EXCEPTION] [DEBUG] [FND_JDBC_PLSQL_RESET]:[false]
              [090412_095442218][][EXCEPTION] [DEBUG] [FND_JDBC_CONTEXT_CHECK]:[true]
              [090412_095442218][][EXCEPTION] [DEBUG] [NLS_DATE_FORMAT]:[DD-MON-RR]
              [090412_095442218][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_DECAY_SIZE]:[5]
              [090412_095442218][][EXCEPTION] [DEBUG] [FND_JDBC_IDLE_THRESHOLD.HIGH]:[-1]
              [090412_095442218][][EXCEPTION] [DEBUG] [NLS_SORT]:[BINARY]
              [090412_095442218][][EXCEPTION] [DEBUG] [NLS_DATE_LANGUAGE]:[AMERICAN]
              [090412_095442218][][EXCEPTION] [DEBUG] [LOGIN_ID]:[-1]
              [090412_095442218][][EXCEPTION] [DEBUG] ------- Properties stored in Java System Properties -------
              [090412_095442218][][EXCEPTION] [DEBUG] [APPLTMP]:[D:\oracle\VIS\inst\apps\VIS_murli\appltmp]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.runtime.name]:[Java(TM) SE Runtime Environment]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.boot.library.path]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\bin]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.version]:[11.0-b15]
              [090412_095442218][][EXCEPTION] [DEBUG] [OVERRIDE_DBC]:[true]
              [090412_095442218][][EXCEPTION] [DEBUG] [dbcfile]:[D:\oracle\VIS\inst\apps\VIS_murli\appl\fnd\12.0.0\secure\VIS.dbc]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.vendor]:[Sun Microsystems Inc.]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vendor.url]:[http://java.sun.com/]
              [090412_095442218][][EXCEPTION] [DEBUG] [path.separator]:[;]
              [090412_095442218][][EXCEPTION] [DEBUG] [APPLCSF]:[D:\oracle\VIS\inst\apps\VIS_murli\logs\appl\conc]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.name]:[Java HotSpot(TM) Client VM]
              [090412_095442218][][EXCEPTION] [DEBUG] [file.encoding.pkg]:[sun.io]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.java.launcher]:[SUN_STANDARD]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.country]:[US]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.os.patch.level]:[Service Pack 2]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.specification.name]:[Java Virtual Machine Specification]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.dir]:[D:\oracle\VIS\inst\apps\VIS_murli\logs\appl\conc\log]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.runtime.version]:[1.6.0_10-b33]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.awt.graphicsenv]:[sun.awt.Win32GraphicsEnvironment]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.endorsed.dirs]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\endorsed]
              [090412_095442218][][EXCEPTION] [DEBUG] [os.arch]:[x86]
              [090412_095442218][][EXCEPTION] [DEBUG] [JTFDBCFILE]:[D:\oracle\VIS\inst\apps\VIS_murli\appl\fnd\12.0.0\secure\VIS.dbc]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.io.tmpdir]:[C:\WINDOWS\TEMP\]
              [090412_095442218][][EXCEPTION] [DEBUG] [line.separator]:[
              ]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.specification.vendor]:[Sun Microsystems Inc.]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.variant]:[]
              [090412_095442218][][EXCEPTION] [DEBUG] [os.name]:[Windows 2003]
              [090412_095442218][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MIN]:[1]
              [090412_095442218][][EXCEPTION] [DEBUG] [cpid]:[2056209]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.jnu.encoding]:[Cp1252]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.library.path]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;D:\oracle\VIS\apps\tech_st\10.1.3\bin;D:\oracle\VIS\apps\apps_st\appl\pon\12.0.0\bin;D:\oracle\VIS\apps\tech_st\10.1.2\bin;D:\oracle\VIS\apps\apps_st\appl\fnd\12.0.0\bin;D:\oracle\VIS\apps\apps_st\appl\au\12.0.0\bin;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\bin;d:\disco_home\jdk\jre\bin\classic;d:\disco_home\jdk\jre\bin;d:\disco_home\bin;d:\disco_home\jlib;C:\Program Files\Oracle\jre\1.3.1\bin;d:\wf_home\bin;C:\Program Files\Oracle\jre\1.1.8\bin;D:\oracle\VIS\apps\tech_st\10.1.2\bin;D:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin\classic;D:\oracle\VIS\apps\tech_st\10.1.2\jdk\jre\bin;D:\oracle\VIS\apps\tech_st\10.1.2\jlib;D:\oracle\VIS\apps\tech_st\10.1.3\bin;D:\oracle\VIS\db\tech_st\11.1.0\bin;C:\mksnt\bin;C:\mksnt\bin\X11;C:\mksnt\mksnt;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\PROGRA~1\Vision;C:\PROGRA~1\Vision\SYSTEM;C:\PROGRA~1\COMMON~1\Vision;C:\Program Files\Microsoft SQL Server\90\Tools\binn\]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.specification.name]:[Java Platform API Specification]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.class.version]:[50.0]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.management.compiler]:[HotSpot Client Compiler]
              [090412_095442218][][EXCEPTION] [DEBUG] [queue_appl_id]:[0]
              [090412_095442218][][EXCEPTION] [DEBUG] [os.version]:[5.2]
              [090412_095442218][][EXCEPTION] [DEBUG] [LONG_RUNNING_JVM]:[true]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.home]:[C:\WINDOWS\system32\config\systemprofile]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.timezone]:[GMT+05:30]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.awt.printerjob]:[sun.awt.windows.WPrinterJob]
              [090412_095442218][][EXCEPTION] [DEBUG] [file.encoding]:[Cp1252]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.specification.version]:[1.6]
              [090412_095442218][][EXCEPTION] [DEBUG] [CACHEMODE]:[DISTRIBUTED]
              [090412_095442218][][EXCEPTION] [DEBUG] [conc_queue_id]:[2158]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.class.path]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\lib\dt.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\lib\tools.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\rt.jar;D:\oracle\VIS\apps\apps_st\comn\java\lib\appsborg2.zip;D:\oracle\VIS\apps\apps_st\comn\java\classes]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.name]:[SYSTEM]
              [090412_095442218][][EXCEPTION] [DEBUG] [DBCFILE]:[D:\oracle\VIS\inst\apps\VIS_murli\appl\fnd\12.0.0\secure\VIS.dbc]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.specification.version]:[1.0]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.home]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.arch.data.model]:[32]
              [090412_095442218][][EXCEPTION] [DEBUG] [user.language]:[en]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.specification.vendor]:[Sun Microsystems Inc.]
              [090412_095442218][][EXCEPTION] [DEBUG] [awt.toolkit]:[sun.awt.windows.WToolkit]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vm.info]:[mixed mode]
              [090412_095442218][][EXCEPTION] [DEBUG] [logfile]:[D:\oracle\VIS\inst\apps\VIS_murli\logs\appl\conc\log\FNDOPP2056209.txt]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.version]:[1.6.0_10]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.ext.dirs]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.boot.class.path]:[D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\resources.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\rt.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\sunrsasign.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\jsse.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\jce.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\lib\charsets.jar;D:\oracle\VIS\apps\tech_st\10.1.3\appsutil\jdk\jre\classes]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vendor]:[Sun Microsystems Inc.]
              [090412_095442218][][EXCEPTION] [DEBUG] [FND_JDBC_BUFFER_MAX]:[2]
              [090412_095442218][][EXCEPTION] [DEBUG] [file.separator]:[\]
              [090412_095442218][][EXCEPTION] [DEBUG] [java.vendor.url.bug]:[http://java.sun.com/cgi-bin/bugreport.cgi]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.io.unicode.encoding]:[UnicodeLittle]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.cpu.endian]:[little]
              [090412_095442218][][EXCEPTION] [DEBUG] [APPLOUT]:[out]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.desktop]:[windows]
              [090412_095442218][][EXCEPTION] [DEBUG] [sun.cpu.isalist]:[pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86]
              [9/4/12 9:54:43 PM] [UNEXPECTED] [2056209:RT5824776] java.io.FileNotFoundException: \tmp\xdofNBNLcD50Q090412_0954436250.fo (The system cannot find the path specified)
                   at java.io.FileOutputStream.open(Native Method)
                   at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
                   at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
                   at oracle.apps.xdo.common.tmp.TmpFile.createTmpFileJDK118(TmpFile.java:146)
                   at oracle.apps.xdo.common.tmp.TmpFile.createTmpFile(TmpFile.java:113)
                   at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:987)
                   at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:212)
                   at oracle.apps.xdo.template.FOProcessor.createFO(FOProcessor.java:1665)
                   at oracle.apps.xdo.template.FOProcessor.generate(FOProcessor.java:975)
                   at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:5936)
                   at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3459)
                   at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3548)
                   at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:285)
                   at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)

              [9/4/12 9:54:44 PM] [2056209:RT5824776] Completed post-processing actions for request 5824776.
              • 4. Re: problem with xml report output
                Srini Chavali-Oracle
                >
                ...
                [9/4/12 9:54:43 PM] [UNEXPECTED] [2056209:RT5824776] java.io.FileNotFoundException: \tmp\xdofNBNLcD50Q090412_0954436250.fo (The system cannot find the path specified)
                >

                Looks like a temporary file is inaccessible or was deleted.

                Was this environment cloned recently ?

                Is a temporary directory defined in XML Publisher ? Use XML Publisher Administrator responsibility, navigate to Home > Administration > Properties > General

                HTH
                Srini
                • 5. Re: problem with xml report output
                  Hussein Sawwan-Oracle
                  Please see these docs.

                  How To Find the EBS XML Publisher Temporary Directory Via SQL? [ID 1189723.1]
                  XML Publisher Reports Fail with java.io.FileNotFoundException on Temp Directory After Cloning [ID 1189764.1]

                  Thanks,
                  Hussein