My Oracle Support Banner

LOCATION GEOMETRY GEOMETRY USING HZ_LOCATION_BO_PUB.UPDATE_LOCATION_BO API (Doc ID 2327181.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information 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


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