Oracle Realtime Scheduler (ORS) Latitude and Longitude Precision is Lost Due to Incorrect NLS_LANG and NLS_TERRITORY Database Instance Settings
Last updated on APRIL 09, 2012
Applies to:Oracle Real-Time Scheduler - Version: 1.13.0
Information in this document applies to any platform.
In the web service log files it can bee seen that stop id 00001240 has the full precision of the latitude and longitude coordinates attached to it prior to the data being written to the database and the job being passed to the Switch. In the RMGW log file however, when the job is picked up as a New stop it is then passed to the scheduler without any precision.
### Steps to Reproduce ###
Enter a Job using the web service and conditional assignment. Search for the job in the scheduler once the gateway has processed the message and it can be seen that the lat long has lost it's precision.
-- Business Impact:
Unable to enter jobs at their true lat/long hence routing is inaccurate
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