Trying to migrate customer contacts using FNDMIG and we are receiving the error:
ORA-20124: Error.NULLVALUE: Field [PERSON_ID] is mandatory for Customer Info Contact and requires a value.
We are currently using the CUSTOMER_INFO_CONTACT view and CUSTOMER_INFO_CONTACT_API
Best answer by RutJWhalen
It appears that although you can manually create a customer contact and toggle to create the person record at the same time this is only available manually and doesn’t appear possible using the migration job.
I resolved my issue by:
updating the CSV file to include a ‘hard-coded’ manually defined PERSON_ID for all records in the CSV file
created the Person records via FNDMIG using PERSON_INFO/PERSON_INFO_API
created the Customer Contact records via FNDMIG using CUSTOMER_INFO_CONTACT/CUSTOMER_INFO_CONTACT_API
Both migration routines using the PERSON_ID that were ‘hard-coded’ in the CSV file.
It appears that although you can manually create a customer contact and toggle to create the person record at the same time this is only available manually and doesn’t appear possible using the migration job.
I resolved my issue by:
updating the CSV file to include a ‘hard-coded’ manually defined PERSON_ID for all records in the CSV file
created the Person records via FNDMIG using PERSON_INFO/PERSON_INFO_API
created the Customer Contact records via FNDMIG using CUSTOMER_INFO_CONTACT/CUSTOMER_INFO_CONTACT_API
Both migration routines using the PERSON_ID that were ‘hard-coded’ in the CSV file.