Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Currency fields get converted automatically into reference currency by Performance Analytics (PA) data collection jobs - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • Currency fields get converted automatically into reference currency by Performance Analytics (PA) data collection jobs
KB0712977

Currency fields get converted automatically into reference currency by Performance Analytics (PA) data collection jobs


1449 Views Last updated : May 18, 2023 public Copy Permalink
KB Summary by Now Assist

Description

This issue can be encountered either on instances using multiple currencies, or on instances with a misconfigured single currency like the following:
  • 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)
 
When you execute a data collection which includes an aggregation on a currency field, the value collected in the pa_scores is the reference value rather than the entered value. When a widget is placed on a dashboard, the expectation would be to see a value in GBP, but instead a USD value is displayed.
 
In case of a misconfigured single-currency instance, setting the glide.system.locale value and re-entering the data in the table has proved to resolve the issue. However, the glide.system.locale property should not be changed once the instance is live, as it causes corruption of all the currency values stored.
 

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

This problem is under investigation. You can Subscribe to this article to receive notifications when more information will become available.

 

 

Related Problem: PRB1303947

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.