Notifications

639 views

Description

An XML import cannot update the value of a currency field because the XML content only contains an amount. A currency field value is represented by an amount and a currency and this information is stored in the fx_currency_instance table. The XML export feature does not include dependent information such as related fx_currency_instance records.

Steps to Reproduce

 

  1. Access an ast_contract record that has a non-zero value in the Payment amount field
  2. Export that record to XML
  3. Open the XML record in a text editor and modify the value in the Payment amount field
  4. Save changes to the XML record and then import it back into the instance
  5. Note the Payment amount value is unchanged

Workaround

Export the data to CSV or Excel and then use Import Sets to move the currency information into another instance.


Related Problem: PRB717932

Seen In

Fuji Patch 13 Hot Fix 1
Geneva Patch 7
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Splunk Sighting Search Integration - Madrid 2019 Q1
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-06-25 14:08:03
Published:2017-08-16