This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,224 Users
  • 2,269,776 Discussions


screen freezes upon calling export pivot data.

810582 Member Posts: 63
edited Jun 24, 2015 6:13AM in JDeveloper and ADF

I'm a newbie to ADF and im having issues while extracting pivot table data.

1. Create a VO with a bind variable.

2. Drag and drop execute with params to the page.

3. Drag and drop data control as pivot table to the page.

4. Add below code in the jsf source above the pivot table

<af:commandButton text="Export To Excel" immediate="true" id="cb1">

                                <dvt:exportPivotTableData type="excelHTML" exportedId="pt2"

                                                          filename="updated_export.xls" title="PivotTable export"/>


5. Run the jsf page.

6. Click on export to excel button, excel gets generated but the screen hangs. user has to forcefully refresh the screen.

Any workarond present for this issue?

Jdev version:12.1.3

Ashish Awasthinitesh KFlorin Marcus

Best Answer

  • Gabriel Sideras
    Gabriel Sideras Athens, GreeceMember Posts: 365 Bronze Badge
    edited Jun 24, 2015 4:21AM Answer ✓


    There is a related bug listed in Oracle Support (Bug 19524936 : AFTER EXPORTING PIVOT TABLE TO EXCEL, SCREEN FREEZES)

    Apply the related patch (Patch 19524936: AFTER EXPORTING PIVOT TABLE TO EXCEL, SCREEN FREEZES) and try again.

    Ashish Awasthi


This discussion has been closed.