Home » Applications » Oracle Fusion Apps & E-Business Suite » Import Account Site email address for customer site (Oracle EBS R12.1.3)
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
Previous Topic: concurrent report request with same parameters
Next Topic: Creating Master Item with Inventory Components
Goto Forum:
  


Current Time: Mon Mar 18 21:47:52 CDT 2024