HZ_LOCATION_PROFILES is Not Getting Updated When HZ_LOCATIONS is Updated

(Doc ID 1917420.1)

Last updated on SEPTEMBER 12, 2016

Applies to:

Oracle Trading Community - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

When using the HZ_LOCATION_v2PUB.update_location API, to update locations, there should be a row inserted into the HZ_LOCATION_PROFILES tables, whenever there is an update in HZ_LOCATIONS.

This is not occuring.

Whenever HZ_LOCATION_v2PUB.update_location is used, to update Address 1, there is a row inserted in HZ_LOCATION_PROFILES.
But, when address_expiration_date, and address_effective_date are updated using API, the record in HZ_LOCATIONS gets updated but a row is not inserted in HZ_LOCATION_PROFILES.

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