|Import Account Site email address for customer site [message #677427]
||Thu, 19 September 2019 04:10
Registered: January 2016
I need to import email address for customer site.
The email should be imported in 'Account Site Email'(attached screenshot) section of the customer site communication details.
I tried using RA_CONTACT_PHONES_INT_ALL interface table and imported, but it is creating contact and the details are imported in 'Account Site Contacts' section.
Furthermore, I read that details can be inserted into HZ_IMP_CONTACTPTS_INT interface table and then imported by submitting 'Import Batch to TCA Registry' program. I tried that but there is no outcome; programs completed successfully but status in interface table shows ERROR (STATUS = 'E', ERROR_ID = '10047', I have no idea how to know what this error means).
Steps I performed to import using TCA program:
1. Generate batch_id using hz_imp_batch_summary_v2pub.create_import_batch
2. Activate batch using hz_imp_batch_summary_v2pub.activate_batch
3. Insert record into HZ_IMP_CONTACTPTS_INT table - Insert statement below
4. Submit 'Import Batch to TCA Registry' program for the generated batch.
INSERT INTO ar.hz_imp_contactpts_int (
'0013000000', --orig_system_reference from hz_parties
'0013000000_1',--orig_system_reference from hz_party_sites of the site for which email has to be imported
I need suggestions on is this approach correct or am I missing anything here?