My Oracle Support Banner

EBS : Custom XML Report Created With BIP 10G Desktop Tool For Crosstab (Pivot) Completed In Error "Namespace prefix 'crosstab' used but not declared" (Doc ID 2020453.1)

Last updated on OCTOBER 27, 2020

Applies to:

BI Publisher (formerly XML Publisher) - Version 5.6.3 to [Release 5 to 10.1]
Information in this document applies to any platform.


Customized Report Completed With Warning Status:

"Namespace prefix 'crosstab' used but not declared"

This can be reproduced with the following steps:
1. Create a custom report using BI Publisher Build 130.
2. Upload the XML in the rtf file and display the data through Pivot Table.
3. When previewed, the result in the Microsoft Excel, the data shown in the output is correct.
4. Registered this program and defined the parameters. Then the registered program was uploaded to the responsibility group and uploaded the rtf template in XML Administrator.
5. However, after running the report the phase is 'Completed' but there is a 'Warning' status.

The log file message is shown below:
+------------- 1) PUBLISH -------------+
Beginning post-processing of request 1390663 on node TAPADEV at 30-MAY-2015 08:57:49.
Post-processing of request 1390663 failed at 30-MAY-2015 08:57:49 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.

The FNDCPOPP Manager log file shows error:

Template code: DD_SCUQ
Template app: PO
Language: en
Territory: 00
Output type: EXCEL

[5/30/15 8:57:49 AM] [51526:RT1390663] Output file was found but is zero sized - Deleted
Caused by: oracle.xdo.parser.v2.XPathException: Namespace prefix 'crosstab' used but not declared.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.