OBIA - When FSG Hierarchies are Enabled, SDE_ORA_GLAccountDimension_HierarchyDerive Fails with "ORA-1452: cannot CREATE UNIQUE INDEX W_GL_ACCOUNT_DS_U1"
(Doc ID 1562971.1)
Last updated on FEBRUARY 17, 2019
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 and later
Information in this document applies to any platform.
In OBIA 188.8.131.52 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
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