You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can change/translate Country Nanme for Value set ORA_CN_COUNTRY

Hi

We created a Country DFF with standard Value Set- ORA_CN_COUNTRY in Person Detail and we have imported the data.

The Value Set- ORA_CN_COUNTRY is a Table value set that selects from cn_geographies_v,

The definition of ORA_CN_COUNTRY is

select geography_name, geography_code

from cn_geographies_v

where geography_type = 'COUNTRY' and geography_use = 'MASTER_REF' 

order by geography_name

The results are

GEOGRAPHY_NAME GEOGRAPHY_CODE

Afghanistan AF

Aland Islands AX

Albania AL

Algeria DZ

American Samoa AS

cn_geographies_v comes from Table hz_geographies

  1. Can we change the country name? ex: Hong Kong to Hong Kong, China. How to change?
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!