Oracle ERP supplier contacts-CodePudding

Before colleagues have suppliers from test environment batch import to formal environment, but there was no will contact supplier in the past,
Now I need to how to set the corresponding test environment supplier contact, add to the corresponding suppliers in formal environment,

CodePudding user response:

To find the corresponding relationship database, and then update

CodePudding user response:

reference 1st floor baidu_36457652 response:

to find the corresponding relationship database, and then update

New

 - contactL_contact_rec ap_vendor_pub_pkg. R_vendor_contact_rec_type; 
- assignment 
- the vendor id 
L_contact_rec. Vendor_id:=l_vendor_id; 
- contact name 
L_contact_rec. Person_last_name:=i_last_name; 
- contact id 
L_contact_rec. Url:=i_id_num; 
- contact phone 
L_contact_rec. Phone:=i_phone; 
- contact fax number l_contact_rec. Fax_phone:=i_fax_num; 
15. - contact email 
L_contact_rec. Email_address:=i_emial_addr; 
- to contact and to place 
L_contact_rec.org _party_site_id:=l_party_site_id; 
- create contact 
Pos_vendor_pub_pkg. Create_vendor_contact (
P_vendor_contact_rec=& gt; L_contact_rec, 
X_return_status=& gt; L_return_status - return status 
X_msg_count=& gt; L_msg_count - wrong number 
X_msg_data=https://bbs.csdn.net/topics/> l_msg_data, error messages, 
X_vendor_contact_id=& gt; L_vendor_contact_id - contact id 
X_per_party_id=& gt; L_per_party_id - contact agency id 
X_rel_party_id=& gt; L_rel_party_id - relations agency id 
X_rel_id=& gt; L_rel_id - relationship id 
X_org_contact_id=& gt; L_org_contact_id - site contact id 
X_party_site_id=& gt; L_party_site_id); - site id

I looked up the API, but convenient parameter I don't know how to go out,

CodePudding user response:

This is called package this look not to come out

CodePudding user response:

This is a problem of oracle ERP, no contact