The apostrophe in the country name of Cote D'ivoire is causing an error when the CMN_COUNTRIES_V view is used in a custom multi select lookup query. When multiple values are selected for the lookup, the apostrophe makes it to where the in() clause does not work correctly.
The country name cannot be modified anywhere in the UI. It is pulled from the CMN_CAPTIONS_NLS NLS table.
Can this country name be updated in the table to Ivory Coast in order to remove the apostrophe?
Release : 15.5
Component : CA PPM Studio
Updating the country name in the CMN_CAPTIONS_NLS table in the database is not supported.
It is recommended to create a custom object containing the country names and using this for the lookup query instead.