Customer Import Fails With Error "You must provide a valid value for the attribute PARTY_SITE_ID." (Doc ID 2678738.1)

Last updated on JUNE 11, 2020

Applies to:

Symptoms

When attempting to load Party Sites, Party Sites Uses , Account Sites, Account Sites Uses etc using Customer Import FBDI, the following error occurs.

ERROR
-----------------------
 You must provide a valid value for the attribute PARTY_SITE_ID.

 The date range for a child record must be within the date range of its parent record.


STEPS
-----------------------
The issue can be reproduced with the following steps:

• 1. Load data into HZ_IMP_PARTYSITES_T,HZ_IMP_PARTYSITEUSES_T,HZ_IMP_ACCTSITES_T,HZ_IMP_ACCTSITEUSES_T etc sheets of Customer Import FBDI Template
• 2. Import Customer Data

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import Party Sites and Account Sites of a Customer

Changes

 No Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.