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.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!