If a currency field of the data is ¥10,000,000 or more, the field is not imported properly.
Steps to Reproduce
- Download the attached xls file (ast_contract.xls) and confirm one of the payment amount values is over ¥10,000,000 (¥12,000,000).
- Navigate to System Import Sets > Load data.
- Select Create table and set any label.
- Select File, choose the downloaded xls file and click the Submit button.
- Click Create transform map.
- Set any name.
- In the Target table field, select Contract [ast_contract].
- In the Related Links section, click Transform.
- Click the Transform button.
- Navigate to Contract > Maintenance.
- Personalize the list and add the Payment amount column.
- 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