'Value for Attribute Common Chart of Account in Stg_<dim>_attr_intf Table Not Present in DIM_COMMON_COA_B table'
Last updated on DECEMBER 18, 2017
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Analytical Applications (OFSAA), 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.
Note: You may get a similar error when loading other key dimensions. Below is an example for Org Unit:
Error. Attribute Value referencing the same table DIM_ORG_UNIT_B. Entries should be inserted before executing the loader program
Error. Value for Attribute OFFSET ORGANIZATIONAL UNIT in stg_org_unit_attr_intf table not present in DIM_ORG_UNIT_B table.
The error prevents you from populating the required attribute for the dimension's members.
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