'Error While Executing Hierachy Query' Running Batch_hierTransformation (rev_batchHierFlatten)

(Doc ID 1372748.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.2.2 to 5.6 [Release 5]
Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.5 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Asset Liability Management Analytics (ALMBI) 5.2.2 or Profitability Analytics (PFTBI) 5.5/5.6, you cannot run the batch_hierTransformation (rev_batchHierFlatten) for the Product dimension.  The batch fails with the following messages in FSI_MESSAGE_LOG:

Hier Id :200101
Deleting Hier Id :200101
null SEQ_1,null SEQ_2,null SEQ_3,null SEQ_4,null SEQ_5,null SEQ_6,null SEQ_7,null SEQ_8,null SEQ_9,null SEQ_10,null SEQ_11,null SEQ_12,null SEQ_13,null SEQ_14,null SEQ_15,null SEQ_16, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(DISPLAY_ORDER_PATH,4,'~') SEQ_17, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(DISPLAY_ORDER_PATH,3,'~') SEQ_18, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(DISPLAY_ORDER_PATH,2,'~') SEQ_19, REV_HIER_TRANSFORMATON_BIAPPS.getTokenValueAt(DISPLAY_ORDER_PATH,1,'~') SEQ_20,
4
Error while executing hierachy Query

This error prevents population of the REV_HIER_FLATTENED table with a Product dimension hierarchy.

You can run rev_batchHierFlatten successfully for other dimensions.

Cause

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