Error Populating OFSA_NODE_DESC Table During the Fsi_batchhierarchyload / Batch_Hier_Load Execution
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)
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:
- Go to Master Maintenance
- Go to Dimension Management > Hierarchies
- Edit a Hierarchy and add a node which has a description that is greater than 80 characters
- Go to Operations > Batch Execution
- Run a Batch with the Reverse Population program Batch_Hier_Load
The error appears in FSI_MESSAGE_LOG.
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