BI Publisher (MOSC)

MOSC Banner

missing user info in audit tables

edited Sep 25, 2012 7:56AM in BI Publisher (MOSC) 3 commentsAnswered
Hi,I have successfully implemented audit reporting on BI Publisher 6 .
I just noticed a small bug in the dataset: for every report run, there is one entry in the table for ReportExecution and one for ReportAccess.
if you run some queries filtered on EVENT_CATEGORY = 'reportAccess' you will know which report is run by who and if you chose the later, it's more which report is memory intensive.
The problem is that for EVENT_CATEGORY = 'reportExecution' the user name is missing so it's going to be difficult to tie a problem to an end user at this point.
Below my query  + screenshot

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center