Number Field Value In Opportunity Is Getting Rounded Off While Import

(Doc ID 1952596.1)

Last updated on JUNE 23, 2017

Applies to:

Oracle Fusion Common CRM Cloud Service - Version 11.1.8.0.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

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.

EXPECTED BEHAVIOR
-----------------------
Opportunity > Custom Field : Margin% > Should be imported with correct decimal value as actual and not get rounded off.

STEPS
-----------------------
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
> Next
  
Step 2: Map Field
> Follow the Column Header from the Mapping.

Step 4: Schedule
> Immediate
 
Step 5: Review and Activate
> Activate
 

Solution

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