My Oracle Support Banner

'Error While Executing Hierachy Query' Running Batch_hierTransformation (rev_batchHierFlatten) (Doc ID 1372748.1)

Last updated on FEBRUARY 28, 2019

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)


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,
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.


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

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