HSDL Worker Business Object - Business Unit mapping error with import

Summary:
Import of csv file error

Content (please ensure you mask any confidential information):

HCM Spreadsheet Data loader template created successfully for Business Object Worker, which is required to import worker personal and assignment details from 3rd party csv.

Lookup mapping was defined/created for 3rd party business unit to match Oracle HCM business units, Value set (table) created whereas 3rd party BU name inputted and to be converted to the Oracle BU name. When manually populating the HSDL on double clicking in the WorkTerms_BusinessUnitShortCode able to search and select the 3rd parties BU name, and by doing so it bring back the correct Oracle BU.