Skip to main content
Solved

Migrating customer contact information

  • September 2, 2025
  • 1 reply
  • 47 views

Forum|alt.badge.img+18

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:

  1. updating the CSV file to include a ‘hard-coded’ manually defined PERSON_ID for all records in the CSV file
  2. created the Person records via FNDMIG using PERSON_INFO/PERSON_INFO_API
  3. 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.

1 reply

Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • 368 replies
  • Answer
  • September 2, 2025

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:

  1. updating the CSV file to include a ‘hard-coded’ manually defined PERSON_ID for all records in the CSV file
  2. created the Person records via FNDMIG using PERSON_INFO/PERSON_INFO_API
  3. 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.