My Oracle Support Banner

"failed: due to oracle.xdo.servlet.data.DataException: Invalid format requested: excel2000" Exception When Selecting BI Publisher Report Output Format Of Excel or CSV (Doc ID 2273797.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Transportation Management Cloud Service - Version 6.4.1 to 6.4.2 [Release 6.4]
Oracle Transportation Management - Version 6.4.1 to 6.4.2 [Release 6.4]
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
When executing a BI Publisher report in OTM and selecting the report output type as Excel or CSV, the below exception is observed.  The report is executed successfully if 'Excel 2007' format is chosen.

ERROR
---------------



EXPECTED BEHAVIOR
-----------------------
It is expected to be able to select a report output successfully with no errors.

STEPS
-----------------------
1.  Select a report to run in OTM  (i.e. Shipment Management -> Reports).

2.  Select 'CSV' or 'Excel' as the Report Format.

3.  Click 'Submit' to generate the rpoert.

4.  The exception is displayed.

Cause

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
Symptoms
Cause
Solution


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