Error oracle.xdo.servlet.CreateException:Report definition not found: /Oracle_Fusion_Middleware_Audit/Common_Reports/User_Activities/Event_Details/Event_Details.xdo [username=weblogicbi] when using 11g BI with OAM report in 10g format

Error oracle.xdo.servlet.CreateException:Report definition not found: /Oracle_Fusion_Middleware_Audit/Common_Reports/User_Activities/Event_Details/Event_Details.xdo [username=weblogicbi] when using 11g BI with OAM report in 10g format

Error

The report cannot be rendered because of an error, please contact the administrator.

Error Detail

Using Business Intelligence publisher to view Oracle Access Manager reports. The Event_Details.xdo report looks fine,
but when clicking on details link under "Event Details" column, the following exception occurs:


oracle.xdo.servlet.CreateException:Report definition not found: /Oracle_Fusion_Middleware_Audit/Common_Reports/User_Activities/Event_Details/Event_Details.xdo [username=weblogicbi]

To resolve this issue, upgrade OAM11g Reports using BIP tool following below steps:


Backup repository directory

$MW_HOME/config/domains/bi_domain/config/bipublisher/repository

Copy AuditReportTemplates.jar

From: $MW_HOME/fmw/112/oracle_common/modules/oracle.iau_11.1.1/reports/AuditReportTemplates.jar

To: $MW_HOME/config/domains/bi_domain/config/bipublisher/repository/Reports 

Extract AuditReportTemplates.jar

cd $MW_HOME/config/domains/bi_domain/config/bipublisher/repository/Reports

jar xf AuditReportTemplates.jar

Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Follow the steps in this post Upgrading Oracle Business Intelligence (BI) Publisher Repository from 10g to 11g

Copy Reports Folder

Copy $MW_HOME/newrep/Reports to $MW_HOME/config/domains/bi_domain/config/bipublisher/repository. Copy only Reports folder

- Start the services.

- Access the reports in Shared Folder > Oracle Fusion Middleware > Common _reports

You may remove OAM folders from below path and use use Common Reports under Oracle_Fusion_Middleware_Audit.There is no need to unzip oam_audit_reports_11_1_2_0_0.zip

/repository/Reports/
/repository/Reports/Oracle_Fusion_Middleware_Audit/Component_Specific


To have OAM specific folder below Oracle_Fusion_Middleware_Audit/Component_Specific, then one needs to unzip oam_audit_reports_11_1_2_0_0.zip f both places.

/repository/Reports/

/repository/Reports/Oracle_Fusion_Middleware_Audit/Component_Specific



Related Posts:

OBIEE Patch 18277370 conflicts with Patch 17611288 installed during OBIA 11.1.1.8.1 installation

Oracle Business Intelligence Enterprise Edition Plus Client 11.1.1.7.0 Installation - Oracle BI Client Installer (64-bit) biee_client_install_x64.exe

Applying OBIA 11g: PATCH OBIEE 11.1.1.7.150120 for for Oracle Business Intelligence Enterprise Edition and Exalytics

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: ] [tid: 1464]  [nQSError: 93001] Can not load library, oracore11.dll, due to, The specified module could not be found error in OBIEE 11g NQSAdminTool.log file

OBI 11.1.1.8.1 -  nQSError : 62022 Javahost has not been configured correctly. Please check your configuration in NQSConfig.ini