Monday, December 4, 2017

Hyperion Financial Reporting logs and checking last used report/date/user id

Recently we were asked to see if there is a way to find out who ran the FR report and when was it run last time/date. 

After doing some research, we found that there is a FR log file called FRLogging.log

File path is E:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\FinancialReporting0\logs

You can search for User and you will find something like this:

[2017-12-04T12:30:19.827-06:00] [FinancialReporting0] [NOTIFICATION] [] [oracle.EPMFR.performance] [tid: 40] [userId: <anonymous>] [ecid: 0000M0Rj2R2AxGK_yTK6yW1Q8wM5000002,0] [APP: FINANCIALREPORTING#11.1.2.0] JOB   : [Start:120417 12:29:55.106-0600][End:120417 12:30:19.827-0600][Elapsed:24.721]
[Host:ServerName][JobId:2][User:hpuser1][Name:/Planning Reports/Current Year Forecast/Employees Report - Forecast]

The syntax has the Host/User ID/Report Name