OBIA - When FSG Hierarchies are Enabled, SDE_ORA_GLAccountDimension_HierarchyDerive Fails with "ORA-1452: cannot CREATE UNIQUE INDEX W_GL_ACCOUNT_DS_U1"
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124 and later
Information in this document applies to any platform.
In OBIA 126.96.36.199 with EBS 11.5.10:
- Enabled FSG hierarchies in the Execution plan.
- This added new task SDE_ORA_GLAccountDimension_HierarchyDerive that loads the data into W_GL_ACCOUNT_DS table.
- When SDE_ORA_GLAccountDimension_HierarchyDerive is trying to create the index W_GL_ACCOUNT_DS_U1 on W_GL_ACCOUNT_DS, it failed with the following error:
ORA-1452: cannot CREATE UNIQUE INDEX W_GL_ACCOUNT_DS_U1
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