This concurrent program enables you to maintain and use price lists in different currencies. Complete the following prerequisites before running this program:
Apply the multicurrency patch only if you want to use the multicurrency feature.
Set the profile QP: Multi-Currency-Installed to Y (yes). The valid list of values for the profile is Y and N. The default value of the profile is N.
Run the Update Price Lists with Multi-Currency Conversion Criteria concurrent program only once.
When you run the concurrent program Update Price Lists with Multi-Currency Conversion Criteria, it does the following:
Adds a new Multi-currency Conversion field to the Advanced Pricing - Price Lists and Pricing Agreements windows. This field displays the name of the multicurrency list currently attached to the price list - you can select other multicurrency lists from this field; however, you can select only one at a time.
Generates a default multicurrency conversion list based on the Base Currency, Currency-To, and Rounding Factor values from existing price lists. This default multicurrency conversion list does not have other currencies or conversion criteria, only the base currency from the base price list. You must add currencies to the newly created multicurrency lists or create new multicurrency conversion lists if you want to include different currencies. You can then attach the multicurrency conversion list to the respective price list.
The following example displays the setup for five price lists before conversion and the multicurrency list created after the conversion:
| Currency | Rounding |
|---|---|
| USD | -2 |
| USD | -2 |
| USD | -3 |
| FRF | -1 |
| CAD | NULL |
The concurrent program creates four currency conversion criteria based on the price list currency and rounding factor of the price lists.
| Currency | Currency-To | Rounding |
|---|---|---|
| USD | USD | -2 |
| USD | USD | -3 |
| FRF | FRF | -1 |
| CAD | CAD | NULL |
Attach the multicurrency conversion list to the respective price list. You can then attach the multicurrency conversion list to the respective price list. You must add new currencies to the existing multicurrency lists or create new multicurrency lists with the currencies required for conversion.
Note: Attaching a multicurrency list to the respective price list is a mandatory step - without it the pricing engine cannot use the current price lists as multicurrency price lists. Once you run the concurrent program, you can create additional multicurrency lists or add existing currencies to the created multicurrency lists.
Report Submission
In the Submit Request window, Name field, select Update Price Lists with Multi-Currency Conversion Criteria.
Report Parameters
Do you want to enable Multi-Currency price lists?: Select Yes to enable multicurrency price lists.
Note: The program must be run initially only once to activate the multicurrency feature; otherwise, data corruption may result. After you have successfully run the concurrent program, all existing price list or agreement windows will be converted to multicurrency price lists. You should not return to non multicurrency price lists. Changing the profile back to N (no) may cause undesired results if conversion criteria have been used. Oracle does not support changing the setting back to No.
Recovery
None. Once you have successfully run the concurrent program , do not return to non-multicurrency price lists. All existing price list windows are converted to multicurrency price lists. Changing the profile option QP: Multi-Currency Installed back to N (no) may cause undesired results if conversion criteria have been used.