PBCS/ EPBCS: Cannot Open Forms in Smart View - "Ad hoc grid can not be opened as there are no valid rows of data"
(Doc ID 2550595.1)
Last updated on OCTOBER 03, 2019
Applies to:Oracle Planning and Budgeting Cloud Service - Version 19.05.53 and later
Information in this document applies to any platform.
When opening a form in ad-hoc mode, an error appears saying “Ad hoc grid can not be opened as there are no valid rows of data”.
This is even if Suppress Missing Blocks has been unchecked per the workaround in the article: PBCS Error "Ad-hoc grid cannot be opened as there are no valid rows of data" When Creating an Ad-hoc Grid In Smart View (Doc ID 1921078.1)
Ad-hoc defaults to the first dimensional members in the page. If there is no data in this intersection, then the form cannot be taken to ad doc.
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