Apostrophe in Country Names Causing Error with a Lookup


Article ID: 196096


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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.