You must perform the following post-upgrade steps if there are multiple values specified for the Column Names attribute while defining lookupby in an Oracle Identity Manager 9.x environment.
If the Oracle Identity Manager 9.x Role or User data model contains UDFs of type Lookup Query, then after upgrading, do the following:
Start the Design Console.
Select User Defined field and select Roles.
Ensure that the property for Column Names and Lookup Column Name is set to the desired column name for the Role Lookup Query UDF. If the value is not present, provide an appropriate value, and click Save.
This updates the MDS definitions. These fields are visible in the Oracle Identity Manager 11.1.2 Administrator user interface.
Start the Configuration Service user interface.
Select User Defined field.
Open the User configuration service, open the UDFs which are of type Lookup By Query. Specify the required value in Column to Display and Column to save fields.
This will update the MDS definitions for the User Lookup Query UDFs. These fields are visible in the Oracle Identity Manager 11.1.2 Administrator user interface.