My Oracle Support Banner

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

Last updated on MAY 13, 2022

Applies to:

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


On : version, Accounts, Contacts, Households

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.

both fields should be updated with blanks

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

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


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

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