HZ_LOCATION_PROFILES is Not Getting Updated When HZ_LOCATIONS is Updated
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.
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.
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