Hello,
Requirement: Extend MainAccountEntity and add 3 additional field that are already present in the main account form. All three fields have separate master table.
Issue: While publishing the data, if we have values in those 3 custom fields, I'm getting following error:
-> A row update in data set MainAccounts was not published. Error message: 'Field validation failed on table of type 'MainAccountEntity' for the following fields: CustomField1.
Infolog: Warning: The value 'abc' in field 'Custom field' is not found in the related table 'Custom field master'..'
I already have the same data in master table which I'm trying to insert, with relation. additionally i have added the field in entity and staging table extension with relation.
if i enter the same value from main account form then i can see the value after refresh.
Please suggest how can i resolve this