Export Table to Excel.... cannot be that simple !

Recently browsing through Listener Tags in ADF I came across ExportCollectionActionListener. I was surprised to see how easy it is to export the collection of records to excel. If you are new to ExportCollectionActionListener, go on reading rest of article.

Drag and Drap the ExportCollectionActionListener to the Export Button or Menu. In the Insert dialog provide the value for ExportedId which should be pointing to table that needs to be exported.

Use the Edit from the action menu Of ExportedId property. Select excelHTML for Type.

Now select the Listener and go the properties and provide the file name and Title and that’s it. Here is the result:

ADF 11g JBO-25002: Definition "VO" of type View Definition is not found Error

ADF 11g JBO-25002: Definition "VO" of type View Definition is not found Error

Generally this is an error encountered at run-time when you try to 'recreate' a VO (view object) in an ADF application. The reason is that, even though the old VO is deleted from the ADF model project, the traces are still left out under the APP Module configuration.

This usually happens when the view objects are associated to the model project App module during VO creation.

To resolve this error, open the App module XML file and remove the reference.

Redeploy the application and you are good to go.