Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Latest data changes are not reflecting in the OTBI report immediately
Hello All,
We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employee, it sometimes takes until the next day for the changes to appear in the report. How can we make the report show changes immediately?
Best Regards,
Nusrat Shaheen
Answers
-
Hello Nusrat,
If you are referring to an OTBI analysis, you could force it to fetch directly from the database and bypass the caching mechanism.
To do that, navigate to the analysis in question:
1. Edit the analysis2. Click on Advanced Tab
3. In the Prefix input box, add the following and click Apply and Save the analysis:
SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;Thank you"
Hassan2 -
Hello Hassan,
Thanks for your reply! I appreciate your time and effort. I'll test this and follow up. Fingers crossed it works!
Best Regards,
Nusrat Shaheen
0 -
You are very welcome.
Hassan
0 -
Hello Hassan,
Thank you for your response. I have followed the same steps as you shared; however, I am still encountering the same issue in AOR, as the latest changes to the data are not reflecting.
Best Regards,
Nusrat Shaheen
0 -
Hi Nusrat,
Are you running these processes immediately after you assign AOR to an employee:
[Retrieve Latest LDAP Changes]
[Send Pending LDAP Request]
Thank you
Hassan
0 -
Ensure you are using an AOR-related real-time subject area, such as:
Workforce Management – Worker Assignment Real Time
Human Capital Management – Areas of Responsibility Real Time0 -
Sometimes it needs a:
Import User and Role Application Security Data
Process to be triggered
0 -
Try running the below:
- Run the “Refresh Manager Hierarchy” Process
- Run “Synchronize Person Records”
0 -
Hi Nusrat,
Can you please confirm if you have run - Refresh Representative Data ESS process? This process should be run daily as per below release notes:
Oracle Fusion Cloud Human Resources 22C What's New
Thanks.
0
