Overview
Oracle CPQ must have a base currency that is defined during set-up. The base currency is the default currency for all users.
Once a base currency is established, Contact Oracle CPQ Ops to add additional currencies. Once added, currencies cannot be removed, but they can be disabled.
Admins can enable or disable supported currencies for either the Host Company or Partner Organizations. For information on how to do this, see the section Enabling and Disabling Currencies below.
User accounts and external company accounts can designate a currency of their preference from the currency set supported by the application.
- Base currencies calculate other currencies in the conversion rates area. For pricing rules, or any time you are returning a price in a function, conversion rates will take effect. The system will assume you are returning currency fields in some currency and it will run the conversion rates for transactions and users with other currencies as their preferred currency.
- Model and parts pricing can be entered into the system in all supported currencies.
- Exchange rate rules can be specified for currency conversion. Currency conversions do not trigger if there is a price defined in the currency preference of the buyer. Currency conversions happen in real-time when a price does not exist in the user’s currency preference, but a base currency price exists along with an exchange rate to the user’s currency preference.
- Commerce transactions use the currency preference of the document originator. Once set, a commerce transaction's currency cannot be changed. This ensures that all commerce documents within the same transaction have the same currency. Both buyers and suppliers can view and modify commerce documents that are in a different currency than their own currency preference.
-
Oracle CPQ supports all currently used currencies. There is no limit to how many concurrent currencies that can be supported per application. You can enable any and all of the currencies that Oracle CPQ supports.
Supported Currencies and Their Currency Codes
| Supported Currency Codes | |
|---|---|
| Currency Name | Currency Code |
| Afghani | AFN |
| Afghani (deprecated) | AFA |
| Algerian Dinar | DZD |
| Antillean Guilder | ANG |
| Argentine Peso | ARS |
| Aurora | MGA |
| Armenian Dram | AMD |
| Australian Dollan | AUD |
| Bahamian Dollar | BSD |
| Bahraini Dinar | BHD |
| Baht | THB |
| Balboa | PAB |
| Barbados Dollar | BBD |
| Belarusian Ruble | BYN |
| Belize Dollar | BZD |
| Bermudian Dollar | BMD |
| Birr | ETB |
| Bolivar Fuerte | VEF |
| Bolivian Mvdol | BOV |
| Boliviano | BOB |
| Brazilian Real | BRL |
| Brunei Ringgit | BND |
| Burundian Franc | BIF |
| Canadian Dollar | CAD |
| Cape Verde Escudo | CVE |
| Cayman Islands Dollar | KYD |
| Cedi | GHS |
| Central African CFA Franc | XAF |
| Chilean Peso | CLP |
| Chinese Yuan Renminbi | CNY |
| Columbian Peso | COP |
| Comoro Franc | KMF |
| Congolese Franc | CDF |
| Convertible Mark | BAM |
| Cordoba | NIO |
| Costa Rican Colon | CRC |
| Crown | CZK |
| Cuban Peso | CUP |
| Dalasi | GMD |
| Danish Krone | DKK |
| Denar | MKD |
| Deutsche Mark (deprecated) | DEM |
| Dirham | MAD |
| Djiboutian Franc | DJF |
| Dobra | STD |
| Dominican Peso | DOP |
| Drachma (deprecated) | GRD |
| East Caribbean Dollar | XCD |
| Egyptian Pound | EGP |
| Emirati Dirham | AED |
| Eritrean Nakfa | ERN |
| Escudo (deprecated) | PTE |
| Estonian Kroon (deprecated) | EEK |
| Euro | EUR |
| Falkland Island Pound | FKP |
| Fiji Dollar | FJD |
| Florin | AWG |
| Forint | HUF |
| Franc | CFAF |
| Franc (deprecated) | BEF |
| Franc (deprecated) | FRF |
| Gibraltar Pound | GIP |
| Gourde | HTG |
| Guarani | PYG |
| Guilder (deprecated) | NLG |
| Guinean Franc | GNF |
| Guyanese Dollar | GYD |
| Hong Kong Dollar | HKD |
| Hryvnia | UAH |
| Icelandic Krona | ISK |
| Indian Rupee | INR |
| Indonesian Rupiah | IDR |
| Iraqi Dinar | IQD |
| Jamaica Dollar | JMD |
| Japanese Yen | JPY |
| Jordan Dinar | JOD |
| Kenya Shilling | KES |
| Kina | PGK |
| Kuna | HRK |
| Kuwaiti Dinar | KWD |
| Kwacha | MWK |
| Kwacha | ZMW |
| Kwanza | AOA |
| Kyat | MMK |
| Lari | GEL |
| Lat | LVL |
| Lebanese Pound | LBP |
| Lek | ALL |
| Lempira | HNL |
| Leone | SLL |
| Leu | MDL |
| Leu (deprecated) | ROL |
| Lev | BGN |
| Leva (deprecated) | BGL |
| Liberian Dollar | LRD |
| Libyan Dinar | LYD |
| Lilangeni | SZL |
| Lira (deprecated) | ITL |
| Litas | LTL |
| Loti | LSL |
| Luxembourg Franc (deprecated) | LUF |
| Malagasy Francs (deprecated) | MGF |
| Malaysian Ringgit | MYR |
| Mali Franc (deprecated) | MLF |
| Malta Lira (deprecated) | MTL |
| Manat | AZN |
| Markka (deprecated) | FM |
| Mauritanian Ouguiya | MRU |
| MauritiusRupee | MUR |
| Metical | MZN |
| Metical (deprecated) | MZM |
| Mexican Unidad de Inversion | MXV |
| Naira | NGN |
| Namibian Dollar | NAD |
| Nepalese Rupee | NPR |
| New kip | LAK |
| New Riel | KHR |
| New Shekel | ILS |
| New sol | PEN |
| New Zealand Dollar | NZD |
| Ngultrum | BTN |
| Niger Franc | XOF |
| North Korean Won | KPW |
| Norwegian Krone | NOK |
| Omani Rial | OMR |
| Ouguiya | MRO |
| Paanga | TOP |
| Pakistani Rupee | PKR |
| Pataca | MOP |
| Peseta (deprecated) | ESP |
| Peso | MXN |
| Philippine Peso | PHP |
| Pula | BWP |
| Punt (deprecated) | IEP |
| Qatar Riyal | QAR |
| Quetzal | GTQ |
| Rial | IRR, YER |
| Riyal | SAR |
| Romanian New Leu | RON |
| Ruble | RUB |
| Rufiyaa | MVR |
| Rwanda Franc | RWF |
| Saint Helena Pound | SHP |
| Sao Tome and Principe Dobra | STN |
| Schilling (deprecated) | ATS |
| Serbian Dinar | RSD |
| Seychelles Rupee | SCR |
| Singapore Dollar | SGD |
| Slovak Koruna (deprecated) | SKK |
| Solomon Island Dollar | SBD |
| Som | KGS, UZS |
| Somali Shilling | SOS |
| Somoni | TJS |
| South African Rand | ZAR |
| South Korean Won | KRW |
| Sri Lankan Rupee | LKR |
| Sudanese Dinar (deprecated) | SDP |
| Sudanese Pound | SDG |
| Surinamese Dollar | SRD |
| Swedish Krona | SEK |
| Swiss Franc | CHF |
| Syrian Pound | SYP |
| Taiwan Dollar | TWD |
| Taka | BDT |
| Tala | WST |
| Tanzanian Shilling | TZS |
| Tenge | KZT |
| Tolar (deprecated) | SIT |
| Trinidad and Tobago Dollar | TTD |
| Tugrik | MNT |
| Tunisian Dinar | TND |
| Turkish Lira | TRY |
| Turkish Lira (deprecated) | TRL |
| Turkmenistani Manat | TMT |
| Ugandan Shilling | UGX |
| Unidad de Fomento | CLF |
| United Kingdom Pound | GBP |
| Uruguayan Peso | UYU |
| US Dollar | USD |
| Vatu |
VUV |
| Venezuelan Bolivar | VES |
| Vietnamese Dong | VND |
| Yugoslav Dinar | YUM |
| Yugoslav Dinar (deprecated) | YUM |
| Zimbabwean Dollar | ZWL |
| Zimbabwean Dollar (deprecated) | ZWD |
| Zioty | PLN |
| Zioty (deprecated) | PLZ |
When 10 or more currencies are being used, fields will be paginated into columns to eliminate horizontal scrolling. Pagination will only occur when five or more currencies are being used in AVP Entry Manager, Price Book Associations, and Customer Specific Pricing (CSP). Five paginated columns will display at a time, each identified by its currency code. Click the left/right arrows to load the next/previous set of columns.
Enabling and Disabling Currencies
For all supported currencies, an Admin can enable and disable their use.
- Click Admin to go to the Admin Home Page.
-
Click Host Company in the General section.
The Host Company Info page opens.
-
In the Base Currency and Supported Currencies section, select Enable for each currency you want to use in CPQ.
Remove the checkmark from the Enable column for each currency you want to disable.
To add currencies to the Base Currency and Supported Currencies section, open a ticket on My Oracle Support.
Once a currency has been added to the Base Currency and Supported Currencies section, it can be enabled or disabled, but it cannot be removed from the Base Currency and Supported Currencies section.
- Click Admin to go to the Admin Home Page.
-
Click Partner Organizations in the Users section.
The Company Administration List page opens.
-
Click the Company Name for the company whose currencies you want to enable or disable.
The Company Administration page opens.
-
In the Supported Currencies section, select Enable for each currency you want to use in CPQ.
Remove the checkmark from the Enable column for each currency you want to disable.
To add currencies to the Base Currency and Supported Currencies section, open a ticket on My Oracle Support.
Once a currency has been added to the Base Currency and Supported Currencies section, it can be enabled or disabled, but it cannot be removed from the Base Currency and Supported Currencies section.
Notes
- In Price Book Associations, column headers will repeat at the bottom of the table for reference in long data sets.
- Currency menus will display alphabetically by currency code, following the FullAccess user’s base currency.
- On the user side, the currency code will be displayed, followed by the display name.
- On the FullAccess user side, the base currency will be highlighted for easy recognition, and precede all other currencies used. When an admin hovers over the currency code, a hover tooltip will display the currency name.
- Document Engine can format all CPQ-supported currencies, as long as the currency symbol is supported by the font.
- Document Designer doesn’t support currency formatting. Instead, use Commerce attributes.
If a customer that is configured for multiple currencies and is integrated with Salesforce (using Oracle CPQ as the Parts Master) wants to use the Delta Parts Export functionality, the Price Book entry Results Parser XSL must be modified.
Ensure that the value for the Salesforce parameter Success is equal to True when creating and editing Partner Price Book ID fields.
