Apostrophe in Country Names Causing Error with a Lookup

book

Article ID: 196096

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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?

Environment

Release : 15.5

Component : CA PPM Studio

Resolution

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.