My Oracle Support Banner

HZ_LOCATION_PROFILES is Not Getting Updated When HZ_LOCATIONS is Updated (Doc ID 1917420.1)

Last updated on MAY 15, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.