Skip to main content

Hi,

 

Is it possible to modify the DEF_ADDRESS in the customer_info_addess_type using data migration ?

 

When i try, i have this message:

 

ORA-20112: CustomerInfoAddressType.FND_RECORD_EXIST: The Customer Info Address Type already exists.

@Julien T.  Bonjour,

Yes it is possible.

Could you please give more contexte? which adresse type? delivery? invoice?….screenshot of the screen?

 

 


I would like to modify the field DEF_ADDRESS of INVOICE address type from TRUE to FALSE.

 

I have to insert a lot of rows in customer_info_addess_type using data migration who use the field DEF_ADDRESS of INVOICE address type with the value ‘TRUE’.

So i have to modify the present rows the field DEF_ADDRESS of INVOICE address type from TRUE to FALSE.

 


@Julien T. 

The error you are getting is because the datamigration job is not able to identify the line to update so he is trying to insert a new line, maybe you are only passing the _DB value of ADDRESS_TYPE_CODE.

 

the source data to be adapted as needed :

 

All field (except OBJID) in the mapping tab are mandatory : 

 

 


Thank you for your answer.

 

I don’t wan’t to put a fixed value in the field CUSTOMER_INFO_ADDRESS_TYPE.DEF_ADDRESS.

 

 


in your 1st screenshot, 

Source Mapping: 

POS : 30 : ADDRESS_TYPE_CODE needs to be populated; the value from ADDRESS_TYPE_CODE_DB is not sufficient (that should correct the error you are having)

 

I don’t wan’t to put a fixed value in the field CUSTOMER_INFO_ADDRESS_TYPE.DEF_ADDRESS.

 

Could you elaborate on the rule to determine which value you want to insert please? and based on what? (source file? value already in database...etc?)