My Oracle Support Banner

PBCS: Duplicate Alias Error in Smart View (Doc ID 2388190.1)

Last updated on APRIL 23, 2018

Applies to:

Oracle Planning and Budgeting Cloud Service - Version and later
Information in this document applies to any platform.


We have a custom Period dimension with multiple hierarchies. There is a different hierarchy for each plan type. Within a single plan type, there are no duplicate aliases, however across the plan types there are duplicate aliases. We have set the hierarchies to not apply to the other plan types, however we are still getting duplicate aliases errors in SmartView. We are looking to confirm if we can have duplicates across the application, but not within the same plan type.
Does the duplicate alias rule apply to the application or the plan type?

The issue is that we have one member's name the same as another member's alias. The 2 members are in separate/mutually exclusive plan types. Smart View throws an Alias error when retrieving/drilling on the dimension. no error on DB refresh, just data retrieval via SV.


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

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