I am getting issue in OTBI Usage Tracking wherein I had used the above Subject areas - OTBI Usage Tracking , however for some reason its not showing the data for recent weeks.
Is their any job or setting that we need to enable for the same ?
HI @Prateek Dhawan,
Not aware of any special settings or jobs but this SA only holds last 6 months of data.
Please take a look into the following doc and following post which might be useful
https://docs.oracle.com/en/cloud/saas/human-resources/25a/faohb/OTBI-Usage-Real-Time-SA-97.html#Description
Real Time OTBI Usage & Performance — Cloud Customer Connect
Just to make sure BI cache or browser cache is not creating the issue, please clear the BI Cache and browser cache & cookies, logout & close the browser and then again have a fresh login to check if there's any betterment.
Hope this help.
Thank you.
Thanks . Have Tried suggested steps . However no luck
Hi Prateek,
Quick questions:
Are you getting any data with usage SA?
Are there any particular set of reports or subject areas that you are not getting for recent weeks?
Are you getting any other data for the recent weeks? like not getting any data from say 5 of this month for any reports. OR getting data for few reports but not for all?
Are you getting any data with usage SA?- yes
Are there any particular set of reports or subject areas that you are not getting for recent weeks?- not coming data from any SA from particular date but before able to see data before that
Not getting data from any SA from particular date(say mid of Feb) but before able to see data before that
Thanks for the details.
If possible please attach your report xml / catalog here so that will try to replicate the issue in our instance to see if we are facing the same.
Thanks Bhaskar
Following are the steps that can be used to recreate issue
Steps to recreate
--- Open the Fusion analytics application --- Click on Catalog -- Create Analysis --- Select Subject Area -"OTBI Usage Real Time" --- Select columns in the Criteria Tab Year, Calendar Month, User Name, Report Start Date, Report End Date, Report Execution Count
-- Click on Results Tab Sort the same by Report Start date DESC
Thanks for the details. I've tried in my instance and it is working fine and bringing the Real Time Data.
Here's the report output that I received.
Hi @Prateek Dhawan,
Please find below the report xml that have been used for the above report output.
Thanks for quick reply.
Have used the same xml , however still no luck
Have tried on other environment and have similar issue in that
We are using the application ver
Oracle Fusion Cloud Applications25A (11.13.25.01.0)
Is their any ESS standard job or some table config setting that we can check .?
Have tried clearing cache
I'm not able too replicate the issue in our instances and the data is coming fine for us.
I would recommend to raise with Oracle Support with all associated details and get their valuable suggestions.
Is there a log that can be checked on our side that might help with the issue. I've submitted an SR, however it is currently being bounced around between different areas. Could not establish connection. oracle.xdo.delivery.ssh2.SSHMessageException: Error in decrypting message Current thought is that this is an issue with…
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
We are encountering issues with our OTBI dashboards where there is no option to export to Excel. This seems to be a new issue after the latest update to 26B. I made a change to the report layout (moved one analysis into its own section), and now I cannot export the page. As you can see in my attached photos, the export…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
