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

Last updated on APRIL 11, 2013

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.2.2 to 5.6 [Release 5]
Oracle Financial Services Profitability Analytics - Version 5.5 to 5.6 [Release 5]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 11-Apr-2013.


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.

Steps to Reproduce:

  1. Go to Operations > Batch Maintenance
  2. Create a new Batch and add a Task with TRANSFORM DATA > batch_hierTransformation
  3. Run the batch in Batch Execution
  4. Check the FSI_MESSAGE_LOG table

FSI_MESSAGE_LOG contains the error transforming the hierarchy.


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