After exporting a report to excel with Grouped Columns ,Columns got Swapped (Doc ID 2819112.1)

Last updated on AUGUST 04, 2022

Applies to:

Symptoms

After exporting a report to excel with Grouped Columns ,Columns Swapped.

In Apex report with 4 column groups:
- group Contract has columns: Contract, Vendor, Based On, Invoice Timing, Finance Analyst
- group Live Data has columns: Jan [$] , Feb [$], Mar [$], Apr [$], May [$], Jun [$], Jul [$], Aug [$], Sep [$], Oct [$], Nov [$], Dec [$], Grand Total [$]
- group Invoice has columns: Jan [$], Feb [$], Mar [$], Apr [$], May [$], Jun [$], Jul [$], Aug [$], Sep [$], Oct [$], Nov [$], Dec [$], Grand Total [$]
- group Difference has columns: Jan [$], Feb [$], Mar [$], Apr [$], May [$], Jun [$], Jul [$], Aug [$], Sep [$], Oct [$], Nov [$], Dec [$], Grand Total [$]
- group review has columns: Category, Rating, Opportunity, Risk

The report is an Interactive Grid When using Freeze Columns on column Finance Analyst ( So the first group is in freeze ).

When exporting the report results to CSV and EXCEL, the last column of the second group is swapped with the first column of the third group.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.