BI Publisher giving error for Before Report Trigger

User_4M27J

Hi All,

Can any one please help me on this.

I have developed a report which triggers a package and populate data into a custom table, and that custom table is query on some conditions in the data sets in the report.

While scheduling the report, its running and giving an error.

Actually the before report trigger  is populating data in to the custom table as I can see clearly last update date in the table.

But after triggering the before report, whole report is  getting failed and giving following error message and status as Problem:

Output failed.
[INSTANCE_ID=lnappu008b.1439469102695] [OUTPUT_ID=3369] oracle.xdo.XDOException: java.lang.reflect.InvocationTargetException

And also, when I disabled the trigger and try running the report and then it completes success as data is already populated in the custom table, but we need before report trigger.

Is there any settings i need to make.

Please suggest.

Thanks,

phanindra