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
No comments:
Post a Comment