'Value for Attribute Rollup Signage in Stg_<dim>_attr_intf Table Not Present in FSI_ROLLUP_SIGNAGE_CD Table' in 7.3.1 & 7.3.2

(Doc ID 1514524.1)

Last updated on DECEMBER 20, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.1 to 7.3.2 [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.1 and 7.3.2, when you try to load attribute values to a dimension's members using the dimension member loader, fn_drmDataLoader, the process fails to load the Rollup Signage attribute.  The following error is output to FSI_MESSAGE_LOG:

Error. Value for Attribute Rollup Signage in stg_gl_attr_intf table not present in FSI_ROLLUP_SIGNAGE_CD table.

The error prevents you from populating this required attribute for dimension members.

Steps to Reproduce:

  1. Load data into STG_<dimension>_B_INTF, STG_<dimension>_TL_INTF, and STG_<dimension>_ATTR_INTF
  2. Create a batch and run fn_drmDataLoader
  3. Check FSI_MESSAGE_LOG

The errors exist 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