My Oracle Support Banner

For Smart View Connections In Excel Member Selection Dialog Initially Shows Flat Member List Instead Of Collapsed Hierarchy (Doc ID 2534250.1)

Last updated on NOVEMBER 04, 2021

Applies to:

Oracle Financial Consolidation and Close Cloud Service - Version 19.02.79 and later
Oracle Planning and Budgeting Cloud Service - Version 19.02.79 and later
Oracle Enterprise Performance Reporting Cloud Service - Version 19.02.79 and later
Oracle Tax Reporting Cloud Service - Version 19.02.79 and later
Oracle Enterprise Planning and Budgeting Cloud Service - Version 19.02.79 and later
Information in this document applies to any platform.

Symptoms

You've launched Excel and connected to FCCS via Smart View. You select a dimension and launch the Member Selection dialog. Instead of showing all top-level members neatly collapsed, such that you can expand the applicable parents and navigate down to the desired member, a flat list is displayed. There might be a few collapsed parent members above them.

The view is different among non-administrator users. Administrators always see the collapsed hierarchy when the dialog first opens.

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
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.