Smart View Planning Provider Error When Copying Member From Sheet1 On Server 1 To Sheet2 On Server 2 When Member Have a Different Parent (Doc ID 3006736.1)

Last updated on MARCH 18, 2024

Applies to:

Symptoms

Smart View Planning Provider Error When Copying Member From Sheet1 On Server 1 To Sheet2 On Server 2 When Member Have a Different Parent. Member does exist in both environments.
Per example:

Customer has a shared member with different parent in 2 Planning servers.
1. In Planning server1:
[test prod].[M000125_Grants_Budget]
2. In Planning server2:
[other].[M000125_Grants_Budget]
In Excel, SmartView options setting is set to display "Member Name or Alias"
It will display "M000125_Grants_Budget" only.

Then select and copy paste to other server's ad hoc sheet, SVC will copy over full member name, e.g. [test prod].[M000125_Grants_Budget]
Since this full member name does not exist in server2 in the same location customer get message: Smart View Planning Provider Error.

According to customer the above behavior does work when doing the process on a On-Prem environment.

Changes

 N/A

Cause

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