Pivot Table Report Output Looks Different in OTM vs outside OTM
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Management - Version 6.0 and later
Information in this document applies to any platform.
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
Expect report to display the data as per report layout/template.
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
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