Error Populating OFSA_NODE_DESC Table During the Fsi_batchhierarchyload / Batch_Hier_Load Execution (Doc ID 1498567.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 to 7.3.1 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3 / 6.0, when running the Reverse Population program Batch_Hier_Load / FSI_BATCHHIERARCHYLOAD function, the following error is written in FSI_MESSAGE_LOG:

"Error. Problem while loading node desc insert into ofsa_node_desc"

Users recently updated a hierarchy and added some new nodes that had descriptions that are more than 80 characters in length.

Steps to Reproduce:

  1. Go to Master Maintenance
  2. Go to Dimension Management > Hierarchies
  3. Edit a Hierarchy and add a node which has a description that is greater than 80 characters
  4. Go to Operations > Batch Execution
  5. Run a Batch with the Reverse Population program Batch_Hier_Load

The error appears in FSI_MESSAGE_LOG.

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