If a currency field of the data is ¥10,000,000 or more, the field is not imported properly.

Steps to Reproduce

  1. Download the attached xls file (ast_contract.xls) and confirm one of the payment amount values is over ¥10,000,000 (¥12,000,000).
  2. Navigate to System Import Sets > Load data.
  3. Select Create table and set any label.
  4. Select File, choose the downloaded xls file and click the Submit button.
  5. Click Create transform map.
  6. Set any name.
  7. In the Target table field, select Contract [ast_contract].
  8. In the Related Links section, click Transform.
  9. Click the Transform button.
  10. Navigate to Contract > Maintenance.
  11. Personalize the list and add the Payment amount column.
  12. Confirm that the Payment amount field of one of records (Test 3) is ¥1.2.


Fix the values in staging table before applying the transform.

Related Problem: PRB669470

Seen In

Geneva Patch 1 Hot Fix 7

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:32:00