We get the error “The values Element Name, Legislative Data Group Name aren’t valid for the attribute ElementTypeId.” when we try to load the element entries, cost info, cost allocation, and cost allocation account business objects.
Even if we provide the right Element Code and Legislative Data Group name, some rows will return this error.
To resolve this error, we need to query the database and get the ElementTypeId and pass it on the HDL file.
select base_element_name, element_type_id from pay_element_types_vl where base_element_name = <Element Name>;We can leave the existing Element Name/Code and LDG as it is on the HDL file and add the ElementTypeId at the end of the file for all rows.
Sample HDL with ElementTypeID added:
METADATA|CostInfoV3|EffectiveEndDate|EffectiveStartDate|SourceType|ElementEligibilityName|ElementCode|LinkInputName|LegislativeDataGroupName|CostableType|CostedFlag|TransferToGlFlag|ElementTypeId
MERGE|CostInfoV3|4712/12/31|1951/01/01|EL|Entitlement Result Full time|Entitlement Result||US Legislative Data Group|C||Y|300000004106903This way the entries will get loaded successfully.
