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.
Solved
Is it possible to modify the DEF_ADDRESS in the customer_info_addess_type using data migration ?
+3Best answer by N.GEORGI
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?)
Yes it is possible.
Could you please give more contexte? which adresse type? delivery? invoice?….screenshot of the screen?
+3I 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.
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 :
+3Thank 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?)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.