Many a times there is a need to view and edit data existing in an Oracle EBS Forms in Excel. Oracle has made this very easy, you can achieve this with few clicks.
You can only export the data which is in tabular format in forms. That is, you can export data of only detail section in a Master - Detail form, you cannot export the data in Master section of Master - Detail form
Here is a sample Master Detail form in Oracle Apps R12.
To Export the data in detail section of the form you need to place the cursor in any field of the detail section and click File -> Export menu.
Note: The Export option will be disabled in the menu by default, it will get enabled only when the cursor is in detail block of the Master Detail form.
Once you click Export option in the menu the data will be exported and if you have Excel or similar Spreadsheet software installed, it will be opened and you will see the data in the Excel sheet.
For Example, suppose we need to export "Key Flexfield Segments" data to Excel then do the following
Login to Oracle Apps and open General Ledger -> Setup -> Financial -> Flexfields -> Key -> Segments form
The Segments form will open as shown below
Place the cursor in Application field and press F11 (Enter Query) and Ctrl+F11 (Execute Query)
Once you click these keys the data will be populated in the form as shown below
You can now press Up or Down arrow keys to view different flexfields.
Once your desired flexfield is shown, place the cursor in any field of the detail section and Click File - > Export menu as shown below
As soon as you click Export you will see the "Progress" dialog showing the status of data export, as shown below
After Oracle has finished exporting the data ( it will actually generate and saves the data in Excel Sheet) you will get a dialog window to open the Excel Sheet as shown below
Press OK to open the file in Spreadsheet program and you will see the data in the sheet as shown below
That's it! this is how easily you can export the data of any Oracle E Business Suite form to Excel
Thanks for reading.