The Currencies page allows you to map a number format mask to a specific currency so that your reports can display multiple currencies with their own corresponding formatting. Currency formatting is only supported for RTF and XSL-FO templates.
To utilize currency formatting, you must:
Define a Currency Format Set.
Add the specific currency format masks to the set.
Assign the Currency Format Set as a configuration property at the desired level (site, data definition, or template). It is available from the FO Processing Properties list.
Enter the format-currency command in your RTF template to apply the format to the field at runtime. See Currency Formatting.
To define a Currency Format Set:
Navigate to the Currencies page under the Administration tab. Select Create Currency Format Set.
Enter a Name and a Code for the set. The Code is a unique identifier and cannot be changed later. Select Apply.
The Currency Formats page will display for your newly created set.
To add currency formats to the Currency Format Set:
Select Add Currency Format to add a format to your set.
Select a Currency Name from the list.
Note: This list is generated from the FND currency table and should include all ISO currencies. Additional currencies can be added from the System Administrator responsibility.
Enter the Format Mask you wish to use for this currency and select Apply.
The Format Mask must be in the Oracle number format. The Oracle number format uses the components "9", "0", "D", and "G" to compose the format, for example: 9G999D00 where
9 represents a displayed number only if present in data
G represents the group separator
D represents the decimal separator
0 represents an explicitly displayed number regardless of incoming data
See Using the Oracle Format Mask for more information about these format mask components.
After a currency format has been created, you can update or delete it from the Currency Formats page.