11 Replies Latest reply on Dec 19, 2012 9:33 AM by EBSDBA

    XML Publisher with Matrix Report

    user12879396
      I build a matrix report in oracle BI publisher(rtf) it generate the output. While it published in oracle apps this rtf then it raise warning before template run successfully after rtf template it generate XML but did not show the output where the matrix design

      Edited by: user12879396 on Mar 13, 2012 5:36 AM

      Edited by: user12879396 on Oct 3, 2012 2:37 AM
        • 1. Re: XML Publisher with Matrix Report
          user12879396
          Please any body guide me


          I build a matrix report in oracle XML publisher(rtf) it generate the output. While it published in oracle apps this rtf then it raise warning before template run successfully after rtf template it generate XML but did not show the output.

          Edited by: user12879396 on Oct 3, 2012 2:36 AM
          • 2. Re: XML Publisher with Matrix Report
            860213
            Please let us know the warning that you get.

            Please check below metalink note id:-

            Matrix Report Completed With Warning - Caused by: java.util.EmptyStackException [ID 1366996.1]

            Also check the OPP log as directed in below metalink note:-

            How can I find the OPP Service log [ID 1494873.1]

            Thanks,
            JD
            • 3. Re: XML Publisher with Matrix Report
              user12879396
              but I am Using the R12 and this patch for Release 11i.

              Apply Patch 7697388 REHOSTING XDOPARSER 10.1.0.5 WITH FIX FOR BUG 7586025, 7339075 FOR 11I.
              • 4. Re: XML Publisher with Matrix Report
                user12879396
                Please I am waiting ofreply

                Edited by: user12879396 on Oct 13, 2012 3:01 AM
                • 5. Re: XML Publisher with Matrix Report
                  Srini Chavali-Oracle
                  Pl post details of OS, database and EBS versions, along with the log of the concurrent program. If you are only seeing XML output, then the setup of XML templates is incorrect/incomplete, or the concurrent encountered an error.

                  HTH
                  Srini
                  • 6. Re: XML Publisher with Matrix Report
                    Hussein Sawwan-Oracle
                    user12879396 wrote:
                    I build a matrix report in oracle BI publisher(rtf) it generate the output. While it published in oracle apps this rtf then it raise warning before template run successfully after rtf template it generate XML but did not show the output where the matrix design
                    What is the warning/error message?

                    Can you find any errors in concurrent request log file?

                    Any errors in the OPP log files? -- $APPLCSF/$APPLLOG/FNDOPP*.txt

                    Thanks,
                    Hussein
                    • 7. Re: XML Publisher with Matrix Report
                      user12879396
                      RDBMS : 11.1.0.7.0
                      Oracle Applications : 12.1.2

                      OPP Log File Content are the following

                      ---------------------------------------------------------------------------
                      Custom Application: Version : UNKNOWN

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

                      XXABTPOHIRU module: Manpower Report
                      ---------------------------------------------------------------------------

                      Current system time is 14-OCT-2012 12:14:08

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


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

                      Arguments
                      ------------
                      P_USER_ID='1972'
                      year='2010'
                      org_name='First'
                      ------------

                      Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing

                      APPLLCSP Environment Variable set to :

                      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
                      American_America.UTF8

                      '.,'

                      Enter Password:
                      MSG-00031: CP_YEAR 2010
                      MSG-00031: CP_GEN_DATE 14-OCT-2012 12:14 PM
                      MSG-00031: CP_USER APPS
                      MSG-00031: CP_PROJECT FIRST

                      Report Builder: Release 10.1.2.3.0 - Production on Sun Oct 14 12:14:12 2012

                      Copyright (c) 1982, 2005, Oracle. All rights reserved.


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


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

                      ------------- 1) PUBLISH -------------
                      Beginning post-processing of request 3561555 on node HO-ERP-TEST at 14-OCT-2012 12:14:14.
                      Post-processing of request 3561555 failed at 14-OCT-2012 12:14:14 with the error message:
                      One or more post-processing actions failed. Consult the OPP service log for details.
                      --------------------------------------

                      ------------- 2) PRINT   -------------
                      Not printing the output of this request because post-processing failed.
                      --------------------------------------


                      Finished executing request completion options.

                      ---------------------------------------------------------------------------
                      Concurrent request completed
                      Current system time is 14-OCT-2012 12:14:15

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

                      Edited by: user12879396 on Oct 14, 2012 2:55 AM

                      Edited by: user12879396 on Oct 14, 2012 2:55 AM
                      • 8. Re: XML Publisher with Matrix Report
                        Srini Chavali-Oracle
                        What you has posted is the concurrent request log

                        >
                        ...
                        Beginning post-processing of request 3561555 on node HO-ERP-TEST at 14-OCT-2012 12:14:14.
                        Post-processing of request 3561555 failed at 14-OCT-2012 12:14:14 with the error message:
                        One or more post-processing actions failed. Consult the OPP service log for details.
                        ...
                        >

                        Pl review the OPP log (see Hussein's reply above) for this concurrent request and post the details of the error from that log

                        HTH
                        Srini
                        • 9. Re: XML Publisher with Matrix Report
                          Hussein Sawwan-Oracle
                          ------------- 1) PUBLISH -------------
                          Beginning post-processing of request 3561555 on node HO-ERP-TEST at 14-OCT-2012 12:14:14.
                          Post-processing of request 3561555 failed at 14-OCT-2012 12:14:14 with the error message:
                          One or more post-processing actions failed. Consult the OPP service log for details.
                          The OPP log file can be found at $APPLCSF/$APPLLOG/FNDOPP*.txt

                          Thanks,
                          Hussein
                          • 10. Re: XML Publisher with Matrix Report
                            user12879396
                            Sorry for late reply

                            I have check this NOTE

                            Oracle.Xdo.Parser.V2.Xpathexception: Namespace Prefix 'Crosstab' Used But Not Declared [ID 743882.1] in this note they mention the following patch Patch 9811428 and oracle remove this patch from download option, replace with this

                            Patch 12395372: UPDATE FOR BI PUBLISHER DESKTOP 10.1.3.2.1 (5.6.3)

                            am I right or wrong ?

                            This is the OPP LOG

                            Template code: XXABTPOHIRU     
                            Template app: XXCUST     
                            Language: en     
                            Territory: US     
                            Output type: EXCEL     
                            [12/19/12 11:42:07 AM] [UNEXPECTED] [697343:RT4872113] java.lang.reflect.InvocationTargetException     
                                 at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
                                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                                 at java.lang.reflect.Method.invoke(Method.java:597)
                                 at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(XSLT10gR1.java:611)
                                 at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:239)
                                 at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:182)
                                 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:1044)
                                 at oracle.apps.xdo.template.fo.util.FOUtility.generateFO(FOUtility.java:997)
                                 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:5954)
                                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3460)
                                 at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3549)
                                 at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(XMLPublisherProcessor.java:296)
                                 at oracle.apps.fnd.cp.opp.OPPRequestThread.run(OPPRequestThread.java:173)
                            Caused by: oracle.xdo.parser.v2.XPathException: Namespace prefix 'crosstab' used but not declared.     
                                 at oracle.xdo.parser.v2.XSLProcessor.reportException(XSLProcessor.java:806)
                                 at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(XSLProcessor.java:571)

                                 ... 16 more
                                 
                            [12/19/12 11:42:07 AM] [697343:RT4872113] Completed post-processing actions for request 4872113.     
                            0 secs]     
                            [GC 52989K->35898K(61720K), 0.0018160 secs]     
                            [GC 52986K->35907K(61720K), 0.0018460 secs]     
                            [GC 52995K->35908K(61720K), 0.0014240 secs]     
                            [GC 52996K->35913K(61720K), 0.0014680 secs]     
                            [GC 53001K->35918K(61720K), 0.0014530 secs]     
                            [GC 53006K->36203K(61720K), 0.0021110 secs]     
                            [GC 53291K->35993K(61720K), 0.0017140 secs]     
                            [GC 53081K->39371K(61720K), 0.0087720 secs]     
                            [GC 56459K->43065K(61720K), 0.0176650 secs]     
                            [GC 60153K->45722K(62872K), 0.0130020 secs]     
                            [Full GC[Unloading class sun.reflect.GeneratedSerializationConstructorAccessor45]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor47]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor48]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor43]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor69]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor49]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor39]     
                            [Unloading class sun.reflect.GeneratedMethodAccessor17]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor40]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor65]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor44]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor37]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor38]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor42]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor66]     
                            [Unloading class sun.reflect.GeneratedMethodAccessor19]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor41]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor64]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor36]     
                            [Unloading class sun.reflect.GeneratedMethodAccessor14]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor71]     
                            [Unloading class sun.reflect.GeneratedMethodAccessor18]     
                            [Unloading class sun.reflect.GeneratedSerializationConstructorAccessor46]
                            • 11. Re: XML Publisher with Matrix Report
                              EBSDBA
                              Hi
                              I have check this NOTE
                              
                              Oracle.Xdo.Parser.V2.Xpathexception: Namespace Prefix 'Crosstab' Used But Not Declared [ID 743882.1] in this note they mention the following patch Patch 9811428 and oracle remove this patch from download option, replace with this 
                              
                              Patch 12395372: UPDATE FOR BI PUBLISHER DESKTOP 10.1.3.2.1 (5.6.3)
                              
                              am I right or wrong ?
                              You can apply the patch 12395372

                              Thanks