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


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


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(
        at java.lang.reflect.Method.invoke(
        at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLStylesheet(
        at oracle.apps.xdo.common.xml.XSLT10gR1.transform(
        at oracle.apps.xdo.common.xml.XSLTWrapper.transform(
        at oracle.apps.xdo.template.FOProcessor.createFO(
        at oracle.apps.xdo.template.FOProcessor.generate(
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(
        at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(
        at oracle.apps.fnd.cp.opp.XMLPublisherProcessor.process(
Caused by: oracle.xdo.parser.v2.XPathException: Namespace prefix 'crosstab' used but not declared.
        at oracle.xdo.parser.v2.XSLProcessor.reportException(
        at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet(
        ... 16 more


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 (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.


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: