6.) The BAM reports files (process_summary.rptdesign,overall_activity.rptdesign) need to be modified (using Eclispe BIRT plugin) to inlcude Oracle connection details.
7.) Also the Oracle driver needs to be included from BIRT ReportEngine.
Its location is TOMCAT_HOMEbirt\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.3.2.r232_v20090212\drivers
Step6 is mainly required as the h2 database connection details are included and these should be replace with your Oracle database information.
Also,it should be noted that the design files do not have the latest table information. One of the columns for the table NodeInstanceLog (DATE has been replaced with LOG_DATE) has been changed (http://community.jboss.org/message/571322).
Attached please find the example reports. You need to provide the hostname and connection details.
You can not open these design files with the latest BIRT plugin as these reports use 2.3.1.
Download the BIRT designer from http://archive.eclipse.org/birt/downloads/build.php?build=R-R1-2_3_1-200809221151http://archive.eclipse.org/birt/downloads/build.php?build=R-R1-2_3_1-200809221151 and modify the report files process_summary.rptdesign,overall_activity.rptdesign in TOMCAT_HOME/BIRT directory.