The address associated to an account is not getting updated via the file import process (Doc ID 2138743.1)

Last updated on MAY 17, 2016

Applies to:

Oracle Fusion Sales - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Accounts, Contacts, Households

When attempting to update the associated address for an account, using file import, with PartySiteID, the following error occurs:

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

"The reference to the parent entity HZ_LOCATIONS using the identifier column LOCATION_ID is invalid. Details: The parent reference information should be valid when creating a child entity. Ensure that the reference information is not missing or invalid, and that there are no validation errors in the parent record."


As per the error message, customer also used LocationID, but the Status is Unsuccessful.

Customer is trying to upsert, i.e. if record is not present perform insert operation and in case record exits perform update operation for Account and Child entity address both.

The following scenarios were ran as well, with no joy:

1.
When attempting to update the associated address for an account, using file import, with PartyID for Account and LocationID for Address as user key, the following error occurs:

ERROR
-----------------------
The address for this combination of party and date range already exists.

2.
When attempting to update the associated address for an account, using file import, with OriginalSystem and OriginalSystemReference as user keys, the account is updated successfully, but address is inserted every time and not updated. In this case, customer had to use address user key as LocationOrigSystemReference and LocationOrigSystem.

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