Adding a New Country Code

In Oracle Business Analytics Warehouse, country is a domain in Oracle Business Analytics Warehouse with the domain code set to 'W_COUNTRY'. The ISO alpha-2 letter code is stored as a domain code in Configuration Manager.

There are new country codes published by ISO standards, for example, South Sudan Country Code 'SS' is published on August 11, 2011. If new country codes are added in the OLTP, you must add them manually in Oracle BI Applications:

  1. In Configuration Manager, add the new country code as a new domain code to domain 'W_COUNTRY'.
  2. In Configuration Manager, add the new country code as a new domain code to domain 'COUNTRY' for the given Product Line Version.
  3. In Configuration Manager, create the domain maps between the source domain 'COUNTRY' to the target domain 'W_COUNTRY' for the new country code.
  4. Reload the Oracle Business Analytics Warehouse table W_GEO_COUNTRY_D.
  5. Update the source file, file_GeoCountry_ISO_Country_Codes_FUSION.csv, with the new country code.