Number Field Value In Opportunity Is Getting Rounded Off While Import
Last updated on JUNE 23, 2017
Applies to:Oracle Fusion Common CRM Cloud Service - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Information in this document applies to any platform.
Number field value in Opportunity is getting rounded off while import
Created a new number field Margin%, with 2 decimal places, in Opportunity. The field is accepting number with 2 decimal digits in UI. But when importing data using import template, 'Mapping to Import Opportunities', value is getting rounded off. Like, 1.4 is getting rounded off and saving as 1, 1.8 is getting rounded off and saving as 2, etc.
Opportunity > Custom Field : Margin% > Should be imported with correct decimal value as actual and not get rounded off.
The issue can be reproduced at will with the following steps:
Setup and Maintenance > All Task > Manage File Import Activities > Go To Task >
> Action : Create
Step 1: Enter Import Options
> Name =
> Object = Opportunity
> Header row included = TRUE
> Upload From = Desktop
> File Name (Browse) = File.csv (pick it from you desktop)
> Import Mapping = NULL
Step 2: Map Field
> Follow the Column Header from the Mapping.
Step 4: Schedule
Step 5: Review and Activate
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms