Fusion Applications BI Publisher : Order of columns in CSV Output Is Inconsistent (Doc ID 1901170.1)

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