DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, July 4, 2013

Namespace prefix 'crosstab' used but not declared

Report Completed with Warning which shows the OPP error in the log file in R12.1.1

Scenario 
========

When we tried to run an cutom report using RTF we get the following error.

OPP Error LOG
=============

Template code: XX_DOYEN_DEMO
Template app:  SQLAP
Language:      en
Territory:     US
Output type:   EXCEL
[7/4/13 2:43:34 PM] [UNEXPECTED] [2036125:RT5861522] java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor60.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:558)
        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(XSLT10gR1.java:228)
        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(XSLTWrapper.java:177)
        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: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)
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


Solution:
========

Pivot table is used in the RTF Template which is not supported on the latest version of BI . BI Publisher embedded with E-Business is based on 5.6.3 version has limited functionality. 

1.  Please install Patch 12395372 - Update For BI Publisher Desktop 10.1.3.2.1 (5.6.3) for the E-business Publisher Desktop Utility.Ensure no Windows applications such as Outlook are running when installing the Utility. 
2.  Select the Add-Ins tab.
3.  Select Insert - Crosstab.
4.  Create the Crosstab there using the Crosstab Wizard.
5.  After Crosstab is created, Validate Template to ensure it runs successfully.

OR

Work Around :
===========

Remove the Pivot table in the RTF Template and test by running the report

Reference :
=========

Note :1   Oracle.Xdo.Parser.V2.Xpathexception: Namespace Prefix 'Crosstab' Used But Not Declared [ID 743882.1]

Note :2   How to Create Crosstab Report In XML Publisher In E-Business Suite Publisher Desktop Utility? [ID 1313546.1]

No comments: