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 APRIL 19, 2017

Applies to:

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

Symptoms

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

Changes

None

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms