EIM : Error SBL-EIM-00205: No foreign key join relation for EIM_PROD_EXT.OUPRDXTXBCSDISTRIC

Hi All,

when we tried to delete Account data from S_ORG_EXT table as part of Account Structure changes, we started noticing some issues..

Error SBL-EIM-00205: No foreign key join relation for EIM_PROD_EXT.OUPRDXTXBCSDISTRIC.

Error SBL-EIM-00205: Failed to load the application dictionary.

we did some analysis on EIM_PROD_EXT.OUPRDXTXBCSDISTRIC and found that it is mapped to a custom extension column X_BCS_DISTRICT on S_ORG_PRDEXT, acting as a foreign key column for S_ORG_EXT.

 

EIM Mapping Wizard has created three foreign key mapping columns ie OUPR_X_BCSACCNT_BI, OUPR_X_BCSACCNTLOC and OUPR_XBCSACCNTNAME and also created an attribute column OUPRDXTXBCSDISTRIC in EIM_PROD_EXT for X_BCS_DISTRICT.