Fusion Applications BI Publisher : Order of columns in CSV Output Is Inconsistent
Last updated on OCTOBER 14, 2014
Applies to:
Oracle Fusion Incentive Compensation Cloud Service - Version 11.1.4.0.0 to 11.1.9.0.0 [Release 1.0]Oracle Fusion Application Toolkit - Version 11.1.4.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 and later
Information in this document applies to any platform.
Symptoms
ISSUE STATEMENT
--------------------------------
When running report for CSV output where all columns are populated the headings in the csv output will be in the order in which they are selected.
However, if the first row of the output has a column which contains null value, then the order of the column heading becomes different. On top of that, if all rows have null value for a column, the column is not shown in the output at all.
ENVIRONMENT
-----------------------
Fusion Applications Cloud
Release 8
STEPS
---------
The issue can be reproduced with the following steps:
1.Run a XMLP report to CSV output
ACTUAL BEHAVIOR
-------------------------------
The order of the Column header changes dependent on whether or not a NULL value exists in the first row of the output
EXPECTED BEHAVIOR
-----------------------------------
The Column header should display consistently regardless of the content of the first row
BUSINESS IMPACT
------------------------------
The report header order changes which causes issues when end users are trying to interpret the results
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