Hierarchy Flattening is Failing in OFSAA 8.0.5 When "ampersand" ("&") is Used in the Member Name
Last updated on MAY 04, 2018
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management Analytics - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI) previously known as Oracle Financial Services Profitability Analytics
During hierarchy flattening, it has been observed that the Org Units as well as another custom dimension were failing whenever there was a presence of "&" in the respective _TL tables (e.g: dim_org_unit_tl).
Below entries were found in FSI_MESSAGE_LOG:
1465 20 Mode and Hier Id :2--200541
1465 20 Deleting Hier Id :200541
1465 20 vSQL: select rev_hier.hierarchy_id from rev_hierarchies rev_hier, rev_hier_definitions rev_hier_def where rev_hier.hierarchy_id =rev_hier_def.hierarchy_id and rev_hier_def.flattened_rows_completion_code='PENDING' and
rev_hier.dimension_Id = 1 and rev_hier.hierarchy_id = 200541
1465 20 Updating Hier Id :200541
1465 20 Batch Hierarchy Load Overload
1465 20 Successfully transformed hierarchy 200541
STEPS TO REPRODUCE
The issue can be reproduced at will with the following steps:
1. create Organizational Unit member
2. Edit ORG_UNIT member to contain "&":
3. Create batch for running hierarchy flattening.
4. Execute batch as showed in UI screenshots.
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