Unable to open Adhoc Grid as it appears as "Ad hoc grid can not be opened as there are no valid rows of data"

(Doc ID 2390475.1)

Last updated on APRIL 27, 2018

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version 18.04.62 and later
Information in this document applies to any platform.

Symptoms

The user reported that whenever the US region tries to access the Smart View they get the below error but it works fine for Germany users
Ad hoc grid can not be opened as there are no valid rows of data

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms