My Oracle Support Banner

On 8.0.9 Hierarchy Transformation Failed With User-Defined Exception Due to Ampersand in Member Description (Doc ID 2660792.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.9 and later
Oracle Financial Services Data Foundation - Version 8.0.9 and later
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.7 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Data Foundation (FSDF)

Symptoms

When running Hierarchy Transformation, the process failed with below error showing reference to ampersand.

Error:
SELECT 11 DIMENSION_ID, 609342 HIERARCHY_ID , LEAF_NODE , null LEVEL_1_CODE,null LEVEL_1_NAME,null LEVEL_2_CODE,null LEVEL_2_NAME,null LEVEL_3_CODE,null LEVEL_3_NAME,null LEVEL_4_CODE,null LEVEL_4_NAME,null LEVEL_5_CODE,null LEVEL_5_NAME,null LEVEL_6_CODE,null LEVEL_6_NAME,null LEVEL_7_CODE,null LEVEL_7_NAME,null LEVEL_8_CODE,null LEVEL_8_NAME,null LEVEL_9_CODE,null LEVEL_9_NAME,null LEVEL_10_CODE,null LEVEL_10_NAME,null LEVEL_11_CODE,null LEVEL_11_NAME,null LEVEL_12_CODE,null LEVEL_12_NAME,null LEVEL_13_CODE,null LEVEL_13_NAME,null LEVEL_14_CODE,null LEVEL_14_NAME,null LEVEL_15_CODE,null LEVEL_15_NAME,null LEVEL_16_CODE,null LEVEL_16_NAME,null LEVEL_17_CODE,null LEVEL_17_NAME,.. etc
REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_PATH,3,'&') LEVEL_18_CODE, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_NAME_PATH,3,'&') LEVEL_18_NAME, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_PATH,2,'&') LEVEL_19_CODE, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_NAME_PATH,2,'&') LEVEL_19_NAME, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_PATH,1,'&') LEVEL_20_CODE, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(NODE_NAME_PATH,1,'&') LEVEL_20_NAME
Error while executing hierarchy Query
Oracle Error User-Defined Exception

Steps to Replicate:
1. Ran Hierarchy Transformation: batch_hierTransformation
2. The process failed with user-defined error in FSI_MESSAGE_LOG
3. Found & ampersand used in a dimension name.
4. Removed the & sign and the hierarchy transformation is successful

 

Changes

Applied Patch 30330054 OFS AAAI Minor Release 8.0.9.0.0 and Patch 30692880 FSDF Minor Release 8.0.9.0.0.

Cause

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
Symptoms
Changes
Cause
Solution
References


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