XMLViewService retrieving stale data

User_9SPJ8

We are experiencing an issue when calling an OBI report via the XMLViewService web service. After updating the data in the database, the web service call will continue to return the older results for 10-15 seconds, then finally after multiple refreshes, the new data is displayed.

At the same time in another browser, I have the OBI web page open and I can refresh the exact same report using the "Refresh" link, and the data renders the new data immediately.

We have caching turned off in the RPD physical layer for this table and we have also disabled the cache on the report we are using.

We are using OBIEE v.11.1.1.7.160119

We have also tried to set the refresh property in the XMLQueryExecutionOptions Structure that says it should force a refresh, but this does not seem to work either.

boolean refresh - If set to TRUE, then the server re-submits the query to refresh the data. If set to FALSE, then the Oracle Business Intelligence Server uses data in the cache.

Has anyone else experienced this issue or have any other suggestions for us to try?

Oracle support is telling me this is expected behavior, but if that were the case, I'd expect it to work the same no matter how we execute the Analysis.

Any help in resolving this would be greatly appreciated.

Thanks,
Rich