My Oracle Support Banner

Longitude And Latitude Values Are Not Updated Properly If #NULL Value Is Provided (Doc ID 2508712.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Accounts, Contacts, Households

ACTUAL BEHAVIOR
---------------
Longitude and Latitude values are not updated properly in Production if #NULL value is provided

You are having an issue with longitude and latitude values if #NULL value is proved in the simplified account import file.

Initially an account has longitude and latitude value as 11.11 and 22.22 respectively.When you tried to blank out the values by providing #NULL in both fields by using simplified account load then instead of blanking out values its updated with weird value as "- 9.9999999999999999999999999999999999999E37". Its happening with both fields. If you provide different values then its updating correctly.If you provide #NULL value then this issue is occurring.

EXPECTED BEHAVIOR
-----------------------
both fields should be updated with blanks

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to OSC
2. Import an account file with Long and Lat filled in with #NULL
3. Field is updated with -9.99999999

BUSINESS IMPACT
-----------------------
This issue is impacting address that customer wants to blank out address longitude and latitude.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.