'Error. No Data Found. Check FSI_DIM_ATTRIBUTE_MAP Table' Running Update_Dimension_Code (Doc ID 1573450.1)

Last updated on AUGUST 07, 2013

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA) 6.0.3

Symptoms

In Financial Services Applications (OFSAA) 6.0.3, you get the following error in FSI_MESSAGE_LOG when running the program Update_Dimension_Code for a dimension like Org Unit, GL Account, Common COA or Product:

Starting Updation of Code column
Error. No data found. Check FSI_DIM_ATTRIBUTE_MAP table
Error. The attribute should present in the REV_DIM_ATTRIBUTES_B/TL table
Error. The attribute should configured FSI_DIM_ATTRIBUTE_MAP table with v_update_b_code_flag = Y

The error prevents the dimension "Code" columns from being updated with values.

Steps to Reproduce:

  1. Go to Operations > Batch Maintenance
  2. Create a new Batch & Task with TRANSFORM DATA
  3. Add the rule Update_Dimension_Code to the Task with a parameter of '1' for Org Unit
  4. Run the Batch
  5. Check FSI_MESSAGE_LOG for errors

There is a "no data found" error.

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