LOCATION GEOMETRY GEOMETRY USING HZ_LOCATION_BO_PUB.UPDATE_LOCATION_BO API

(Doc ID 2327181.1)

Last updated on NOVEMBER 14, 2017

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.

Cause

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