Customer contact interface and API import

Customer contact information, you can use the interface table Ra_contact_phones_int_all

After the import is finished, you can hz_contact_points the table by owner_table_id (value for party_site_id)

based on the interpretation of the Ra_contact_phones_int_all table field orig_system_address_ref :

Unique address identifier from foreign system. If This value is NULL, the phone or contact is for the entire customer

can control whether contact information applies to the entire customer tier, or to a location layer

--------------------------------------------------------------------------------------------------------------- ----------------------------------------

If you use the API, use the following script:

DECLARE P_contact_point_rec hz_contact_point_v2pub.  Contact_point_rec_type;  P_phone_rec Hz_contact_point_v2pub.phone_rec_type;  P_edi_rec_type Hz_contact_point_v2pub.edi_rec_type;  P_email_rec_type Hz_contact_point_v2pub.email_rec_type;  P_telex_rec_type Hz_contact_point_v2pub.telex_rec_type;  P_web_rec_type Hz_contact_point_v2pub.web_rec_type;  X_CONTACT_POINT_ID number;  X_return_status VARCHAR2 (2000);  X_msg_count number; X_msg_data VARCHAR2 (2000);  BEGIN fnd_global.apps_initialize (1231, 50886, 222);    Mo_global.init (' AR ');  P_contact_point_rec.contact_point_type: = ' PHONE ';  P_contact_point_rec.owner_table_name: = ' hz_party_sites '; p_contact_point_rec.owner_table_id: = 53224;  --<value for party_site_id from step 4> p_contact_point_rec.created_by_module: = ' hz_cpui '; P_phone_rec.  Phone_number: = ' 40755556 ';  P_phone_rec.phone_line_type: = ' GEN '; --/*p_contact_point_rec.contact_point_type: = ' PHONE';  P_contact_point_rec.owner_table_name: = ' hz_party_sites '; p_contact_point_rec.owner_table_id: = 53224;  --<value for party_site_id from step 4> p_contact_point_rec.created_by_module: = ' hz_cpui '; P_phone_rec.  Phone_number: = ' 40755556 ';  P_phone_rec.phone_line_type: = ' FAX ';  ----P_contact_point_rec.contact_point_type: = ' EMAIL ';  P_contact_point_rec.owner_table_name: = ' hz_party_sites '; p_contact_point_rec.owner_table_id: = 53224;  --<value for party_site_id from step 4> p_contact_point_rec.created_by_module: = ' hz_cpui '; P_email_rec_type.                                              email_address: = ' [email protected] ' */--hz_contact_point_v2pub.create_contact_point (' T ',                                              P_contact_point_rec, P_edi_rec_type,                                       P_email_rec_type, P_phone_rec,       P_telex_rec_type, P_web_rec_type,                                              x_contact_point_id, X_return_status,  X_msg_count, X_msg_data);  Dbms_output.put_line (' *************************** ');  Dbms_output.put_line (' Output information .... ');  Dbms_output.put_line (' x_contact_point_id: ' | | x_contact_point_id);  Dbms_output.put_line (' x_return_status: ' | | x_return_status);  Dbms_output.put_line (' X_msg_count: ' | | x_msg_count);  Dbms_output.put_line (' x_msg_data: ' | | x_msg_data); Dbms_output.put_line (' *************************** '); END;

Created_by_module This field is a must, and must be obtained from the lookup code "Hz_created_by_modules", but the meaning is unknown.

Lookup Code View path: AR Superuser, Setup, System, Quickcode, receivables

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Customer contact interface and API import