LOCATION GEOMETRY GEOMETRY USING HZ_LOCATION_BO_PUB.UPDATE_LOCATION_BO API
(Doc ID 2327181.1)
Last updated on MAY 10, 2022
Applies to:
Oracle Trading Community - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, APIs
ACTUAL BEHAVIOR
---------------
Geometry column not updated with correct coordinate values
Using a SOA service to update locations with hz_location_bo_pub.update_location_bo API, the coordinates in the Geometry column for HZ_LOCATIONS are saved as expected.
However in database the coordinates are updated without any "." or ",".
EXPECTED BEHAVIOR
-----------------------
The location coordinates should be saved with dot or comma as per API update.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. prepare the data for the API
2. run the API
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the data is incorrect in database.
Changes
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 |
Changes |
Cause |
Solution |
References |