Customer Data Model: How To Clean Up Data Corruption in Location Information (State, County, City and Postal Code) For Existing Addresses In HZ_LOCATIONS Table?
Last updated on APRIL 04, 2017
Applies to:Oracle Trading Community - Version 11.5.10 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
ARXCUDCI HZ_LOCATIONS ARSYSPA
- Customer / Party Addresses were created with 'Address Validation' set to 'No Validation' in AR System Options.
- Now you need to clean and enrich these addresses in HZ_LOCATIONS and AR_LOCATION_VALUES
- How To Clean Up Bad Location Information (State, County, City and Postal Code) For Existing Addresses In HZ_LOCATIONS Table?
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