My Oracle Support Banner

The HZ_LOCATIONS Table Updated, Even When No Changes Were Made on the Front End (Doc ID 1958130.1)

Last updated on MAY 31, 2018

Applies to:

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


On : 12.1.3 version, Locations

The records in the HZ_LOCATIONS table were updated, even when no changes were made in the form.

Steps to Reproduce:
Responsibility:  Receivables
Navigation:  Customers > Customers
1. Query an existing customer and click on ‘Bill To’ Site Details
2. Without making any changes/updates, click ‘SAVE’ or ‘APPLY’
The Alert 3 gets triggered.
Review the three backend tables (HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS)

Although no changes were made, in frontend application form, you find that the records in the HZ_LOCATIONS table were updated.
Oracle is updating the backend table and the alert is triggered


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.