Description
- i18n.single_currency = true
- i18n.single_currency.code = GBP
- glide.system.locale = no value / null (instead of the locale for the single currency that is being used)
Steps to Reproduce
Setting the system properties below is only required to mis-configure a single currency instance:
- i18n.single_currency = true
- i18n.single_currency.code = GBP
- glide.system.locale = [null]
The following steps are common to both single and multiple currency:
1 - Create a new table currency_pa_test with a currency column
2 - Add two records in currency_pa_test with values 100 and 10
3 - Create an indicator source to collect data from currency_pa_test . fact table = currency_pa_test
4 - Create an indicator based of the indicator source
5 - Create a job with the indicator and execute the job
6 - Check the pa_scores_l1 table /pa_scores_l1_list.do?sysparm_query=
7 - Observe the value collected is the value being displayed (128) in dollars
8 - Check the fx_currency_instance table showing an amount of 100 GBP and a Reference amount of 128.2188 USD /fx_currency_instance_list.do?sysparm_query=amount%3D100
9 - When the collection is run it is collecting the reference amount.
Workaround
Related Problem: PRB1303947