OIM - Some UDFs are missing from Reconciliation Field mapping in the Design console?

 

Some time It may happen, you have created UDFs and some UDFs are not visible in Reconciliation Field mapping. Even though those fields are present in the view form in sysadmin UI and in the USR table in database.

This can happen of the custom UDFs created in the USR table are not being pushed to the SDC table. The Reconciliation Field Mapping will be refered from SDC table.

You can verify if they exist in SDC table:

select sdc_name, sdc_label, sdk_key from sdc;

 

Solution:
In this case, since the SDC table is missing the UDFs, you have only 2 options:

 

1. Restore OIM Schema to before the UDFs were created and then create again.

 

2. Modify display name of UDFs which are missing in SDC table from System Administration Console and then create new UDFs with same display name.(Note: As UDF Name is referred unique value in database, so you have to provide unique name).