Oracle R12 Supplier Interface

A simple code for Supplier Interface

1) Create Supplier through Import
INSERT INTO ap_suppliers_int
(vendor_interface_id, vendor_name,
status)
VALUES (AP_SUPPLIERS_INT_S.NEXTVAL, 'ABC Industries',

'NEW')
;
Vendor_interface_id = 10006, vendor_id = 46220

2) Create Supplier Site using Import
INSERT INTO ap_supplier_sites_int
(vendor_id, vendor_site_code, address_line1, city,
state, zip, country,
org_id, operating_unit_name,
status,
purchasing_site_flag, pay_site_flag,
vendor_site_interface_id)
VALUES (46220, 'SITE1', 'ADDR1', 'Orlando',
'FL', '32803', 'US',
204, NULL,
'NEW',
'Y', 'Y',
AP_SUPPLIER_SITES_INT_S.NEXTVAL)
;

3) Create row in Contact Interface table using the
following:
INSERT INTO ap_sup_site_contact_int
(vendor_site_id, vendor_site_code,
org_id,  operating_unit_name,
first_name, last_name, prefix, title, mail_stop,
area_code,
phone, department, status, email_address, url,
alt_area_code,
alt_phone, fax_area_code, fax, vendor_id,
vendor_contact_interface_id,
vendor_interface_id, last_update_date,
last_updated_by,
creation_date, created_by, last_update_login)
VALUES (NULL, 'SITE1',
204, NULL,
'XYZ', 'YYYY', NULL, NULL, NULL, '787',
'000-0000', NULL, 'NEW', NULL, NULL, NULL,
NULL, NULL, NULL, 46220,
AP_SUP_SITE_CONTACT_INT_S.NextVal,
10006, SYSDATE, -99,
SYSDATE, -99, -99)

Interface Programs:
Supplier Open Interface Import
Supplier Sites Open Interface Import
Supplier Site Contacts Open Interface Import