Import set coalesce failure: coalesce field not found in target table

The coalesce field name is misspelled or has incorrect capitalization in the transform map configuration. (high likelihood)

The field specified for coalescing does not exist in the target table or has been deleted after the transform map was created. (high likelihood)

The transform map is pointing to the wrong target table that lacks the expected coalesce field. (medium likelihood)

The coalesce field is a custom field that was removed or renamed in a recent update or customization. (medium likelihood)

The target table extends another table and the coalesce field exists only in the parent table but the reference is incorrect. (low likelihood)

Step 1: Navigate to System Import Sets > Administration > Transform Maps and locate the failing transform map from the import set log.

Step 2: Open the transform map record and check the 'Coalesce' field value, noting the exact field name specified.

Step 3: Navigate to the target table by going to System Definition > Tables and search for the target table referenced in the transform map.

Step 4: In the target table record, click on the 'Columns' related list to verify that the coalesce field exists and check its exact spelling and case sensitivity.

Step 5: If the field exists but has different spelling, return to the transform map and correct the coalesce field name to match exactly.

Step 6: If the field does not exist, either create the missing field in the target table or change the coalesce field to an existing field like 'number' or 'sys_id'.

Step 7: Test the transform map by running a small subset of the import set data to verify the coalesce operation works correctly.

Step 8: Check the Transform History related list on the import set to confirm successful processing without coalesce errors.