My Oracle Support Banner

Smart View: Data Needs Refresh Twice (Doc ID 2965516.1)

Last updated on AUGUST 21, 2023

Applies to:

Oracle Planning and Budgeting Cloud Service - Version N/A and later
Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.


We are experiencing an issue with Smart View version 23.100 related to reports/grids that have dimension members defined by a formula reference to an Excel cell value.

For example, if I have a Smart View grid that has the Year and Period referencing a cell in a different sheet, and I update the value from say, Q1 to Q2 in that sheet, I would expect that my next refresh of the grid would bring in Q2 numbers, not Q1. This works fine except for after immediately reopening the file. If I reopen a file and change one of those referenced cells, say from Q1 to Q4, then refresh the Smart View grid, it will still bring in Q1 numbers on the first refresh. I must refresh a second time for the numbers to reflect the updated Q4 value references from the other sheet/cell. However, further value updates to the referenced cells and refreshes after having the file open will continue working and changing as normal.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.