Unable To File Import Customers With Multiple Address And Contact Points- CSV

(Doc ID 1454784.1)

Last updated on MARCH 22, 2018

Applies to:

Oracle Fusion Trading Community Model - Version 11.1.2.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Trading Community Model Cloud Service - Version 11.1.4.0.0 to 11.1.7.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.1.2.0.0 version, File Import

When attempting to import customers with more than one address (and different site use type)
the following error occurs.

ERROR
-----------------------

'HZ_NO_CURRENT_PRIMARYSITEUSE'  for table HZ_IMP_PARTYSITEUSES_T
This error appears when the user does not set a primary value among all the address purposes of a party's address.



STEPS
-----------------------

Cause

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