My Oracle Support Banner

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.

Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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