Skip to main content

Trying to migrate customer contacts using FNDMIG and we are receiving the error:  

 

ORA-20124: Error.NULLVALUE: Field lPERSON_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

 

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.

Reply


Terms & ConditionsCookie settings