Import Customer - Unable To Set Creation And LastUpdate Dates (Doc ID 1574017.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.5.0.0 to 11.1.5.0.0 [Release 1.0]
Oracle Fusion Sales - Version 11.1.5.0.0 to 11.1.7.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms


Import Customer - Unable to set creation and LastUpdate Dates  

We are trying to import customer.
The problem is that we cannot manage to set the following four columns, when we map them we have error.
SalesAccountProfile_CreatedBy
SalesAccountProfile_CreationDate
SalesAccountProfile_LastUpdatedBy
SalesAccountProfile_LastUpdateDate
Please check the document attached that describes the problem.


ERROR
-----------------------
HZ Errors
HZ_INVALID_PARTY_FK COLUMN_NAME PARTY_ID
HZ_PRIMARY_SELECTION_REQUIRED COLUMN IDENTIFYING_ADDRESS_FLAG
...
MKT Errors
FND-FND_GENERIC_MESSAGE FND-FND_GENERIC_MESSAGE Party does not have a valid SELL TO ADDRESS (PARTY_SITE_ID)
but also in a transitory way get such errors
MKT_IMP_LOAD_ERROR ATTRIBUTENAME CreationDate VOINSTANCE SalesAccountProfile ERRORMSG JBO-27008: Attribute CreationDate in view object OrganizationProfileVO_SalesAccountInterface_OrganizationProfileVOToSalesAccountInterfacePVO_SalesAccountInterfacePVO cannot be set. at ColumnNumber :11
MKT_IMP_LOAD_ERROR ATTRIBUTENAME CreatedBy VOINSTANCE SalesAccountProfile ERRORMSG JBO-27008: Attribute CreatedBy in view object OrganizationProfileVO_SalesAccountInterface_OrganizationProfileVOToSalesAccountInterfacePVO_SalesAccountInterfacePVO cannot be set. at ColumnNumber :12
MKT_IMP_LOAD_ERROR ATTRIBUTENAME LastUpdateDate VOINSTANCE SalesAccountProfile ERRORMSG JBO-27008: Attribute LastUpdateDate in view object OrganizationProfileVO_SalesAccountInterface_OrganizationProfileVOToSalesAccountInterfacePVO_SalesAccountInterfacePVO cannot be set. at ColumnNumber :13
MKT_IMP_LOAD_ERROR ATTRIBUTENAME LastUpdatedBy VOINSTANCE SalesAccountProfile ERRORMSG JBO-27008: Attribute LastUpdatedBy in view object OrganizationProfileVO_SalesAccountInterface_OrganizationProfileVOToSalesAccountInterfacePVO_SalesAccountInterfacePVO cannot be set. at ColumnNumber :14




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


Note that i tested some who column one day mater for sales account also to avoid that issue is cause by sales account who columns which are before party who columns

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