Pivot Table Report Output Looks Different in OTM vs outside OTM (Doc ID 1643501.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.

Symptoms

A report with pivot table is created in OTM. When attempting to design and view format template in Microsoft Word, it works. But uploading it into OTM, the result is abnormal.
BI Publisher desktop Ver#10.1.3.4.2


EXPECTED BEHAVIOR
-----------------------
Expect report to display the data as per report layout/template.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a cross tab report using query and format template in BI Publisher
2. Using OTM to export data, load data to format template. The format of report looks fine
3. Upload the query and format template to OTM
4. Run the report, report does not look right in OTM with same data query

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