'Value for Attribute Common Chart of Account in Stg_<dim>_attr_intf Table Not Present in DIM_COMMON_COA_B table' in 7.3.1 & 7.3.2 (Doc ID 1514528.1)

Last updated on JANUARY 27, 2017

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.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 Common Chart of Account attribute.  The following error is output to FSI_MESSAGE_LOG:

Error. Value for Attribute Common Chart of Account in stg_gl_attr_intf table not present in DIM_COMMON_COA_B table.

The error prevents you from populating the required attribute for the dimension's members.

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