Oracle RightNow: Retrieving Country and Province IDs

The Country and Province in the address field are entered by IDs via API. Here is how we can retrieve the Country/Province values and their IDs in RightNow interface.

Retrieving Country IDs

  1. Go to Configuration > Databases > Data Dictionary.
  2. Look for Countries in the Tables list.
  3. In the table information, click on the country_id index.

country_id

Retrieving Province IDs

  1. Go to Configuration > Databases > Data Dictionary.
  2. Look for Provinces in the Tables list.
  3. In the table information, click on the prov_id index.

prov_id