| Import Account Site email address for customer site [message #677427] |
Thu, 19 September 2019 04:10 |
 |
adfnewbie
Messages: 54
Registered: January 2016
|
Member |
|
|
Hi Experts,
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 (
batch_id,
cp_orig_system,
cp_orig_system_reference,
party_orig_system,
party_orig_system_reference,
site_orig_system,
site_orig_system_reference,
insert_update_flag,
contact_point_type,
contact_point_purpose,
email_address,
primary_flag,
created_by_module)
VALUES (
10002,
'UNKNOWN',
'TEST001',
'UNKNOWN',
'0013000000', --orig_system_reference from hz_parties
'UNKNOWN',
'0013000000_1',--orig_system_reference from hz_party_sites of the site for which email has to be imported
'I',
'EMAIL',
'INVOICE',
'JackieContact@yahoo.com',
'Y',
'HZ_IMPORT'
);
I need suggestions on is this approach correct or am I missing anything here?
Thanks,
RC
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
