'Value for Attribute Common Chart of Account in Stg_<dim>_attr_intf Table Not Present in DIM_COMMON_COA_B table'
(Doc ID 1514528.1)
Last updated on FEBRUARY 03, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document