"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 JUNE 05, 2017

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

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