In this article you will see a step by step instruction to export data into excel spreadsheet, from an OA Framework page. This can be achieved via very simple personalization to OA Framework page. The first step will be to find out the ViewObject Instance name from which data will be exported. This can be found from "About This Page" functionality. For this demo, Oracle iProcurement home page is used. We will be doing personalization to this page to add an "Export Button". When user clicks on this button, data from OA Framework View Object will be exported into excel spreadsheet. For this example, all the currently open notifications for the current user will be exported to excel spreadsheet. The name of the ViewObject used for exporting data from OA Framework Page is "OpenWorklistVO" in this case, and this can be found from "About This Page".
First find out the name of the ViewObject using "About This Page"
This is our About this Page Information. We can see the View Object from which data will be extracted to Excel
Now that we know the View Object Name, we can click on Personalize
Let us Create a New Item for Export Button
Select Export Button
Attach the View Object to the Export Button being created, and give this button a label
Now let us return to the main iProcurement page
We can now see the button created
Click on the button
Excel Spreadsheet will be opened