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 Oracle BI Applications 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 Oracle BI Applications Configuration Manager, add the new country code as a new domain code to domain 'W_COUNTRY'.
2. In Oracle BI Applications Configuration Manager, add the new country code as a new domain code to domain 'COUNTRY' for the given Product Line Version.
3. In Oracle BI Applications 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.