User activity report transferred from OVO-U to OML wouldn't work - table or view doesn't exist
Since I couldn't find User Activity report on OML, I have transferred the existing one from OVO-U.
Once I run it, I get a message:
opc_audit a, opc_audit_param p, opc_user_data u
ORA-00942: table or view doesn't exist.
I launched a report from a command checking what exactly tables or views are missing and appears, that opc_audit and opc_audit_param tables/views are missing (all other provides me data after I make a select).
I checked reporting and DB structure document for OML9.01 and according to a paper, these tables exists in OML9.01.
I'm not sure, whether I can blame user permissions, since I run a report from Admin UI and it should use same user as for any other that type of report.
Any help is more than appreciated.
Just wanted to update on the status in reagrds my audit data "investigations".
The audit data I'm looking for is not stored in DB anymore and following tools should be considered for gathering suh inforamtion:
You're right - this has been completely rehauled in OM 9.x and the information is no longer
stored in the database. Therefore the old reports are no longer useful.
You can find all this explained in the chapter "HPOM Audits" of the "Administrator’s Reference" manual.
You'll also find the location and the syntax of the audit file there.