BI Publisher Fails on Queries with Large Datasets / OIM 11g
Hi,
We are using BI Publisher 11g for reporting on OIM 11g data. When we execute the report query directly from the database, it takes up to 10 seconds to retrieve the full dataset, however when executed from BI Publisher, product fails with message "Error Occured" (no other information is displayed on the logs as well).
BI Publisher version is 11.1.1.5.0
Thanks
Onur
Query is as follows;
Select * From(
Select 'MODIFY USER FIELD' Action_Type, 'USR' Action_Resource, Upa_Fields.Field_Name Action_Field_Name, Upa_Fields.Field_Old_Value Old_Value, Upa_Fields.Field_New_Value New_Value, Upa_Fields.Create_Date Rep_Create_Date, Usr.Usr_Login usr_login, Usr.Usr_Display_Name Usr_Display_Name, Usr.Usr_Email
We are using BI Publisher 11g for reporting on OIM 11g data. When we execute the report query directly from the database, it takes up to 10 seconds to retrieve the full dataset, however when executed from BI Publisher, product fails with message "Error Occured" (no other information is displayed on the logs as well).
BI Publisher version is 11.1.1.5.0
Thanks
Onur
Query is as follows;
Select * From(
Select 'MODIFY USER FIELD' Action_Type, 'USR' Action_Resource, Upa_Fields.Field_Name Action_Field_Name, Upa_Fields.Field_Old_Value Old_Value, Upa_Fields.Field_New_Value New_Value, Upa_Fields.Create_Date Rep_Create_Date, Usr.Usr_Login usr_login, Usr.Usr_Display_Name Usr_Display_Name, Usr.Usr_Email
0