Suppliers, Supplier Sites, Contacts and Banks Conversion Using Standard Import and API

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

Interface Tables:
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT
IBY_TEMP_EXT_BANK_ACCTS

Rejections Table:
AP_SUPPLIER_INT_REJECTIONS


Using APIs:
APIs involved:


-- API to validate vendor
AP_VENDOR_PUB_PKG.Validate_Vendor

-- API to validate vendor site
AP_VENDOR_PUB_PKG.Validate_Vendor_Site

-- API to validate vendor contact
AP_VENDOR_PUB_PKG.Validate_Vendor_Contact

-- API to  vendor
AP_VENDOR_PUB_PKG.Create_Vendor
AP_VENDOR_PUB_PKG.Create_Vendor_Site
AP_VENDOR_PUB_PKG.Create_Vendor_Contact


-- API call to create bank account
iby_ext_bankacct_pub.create_ext_bank_acct

-- API to  make the party as joint account holder
iby_ext_bankacct_pub.add_joint_account_owner

-- API call to assign bank account to the supplier site
iby_disbursement_setup_pub.set_payee_instr_assignment

-- API to Create Party Tax Profile
zx_party_tax_profile_pkg.update_row


You can use the following APIs if Supplier Management is implemented. Also you can use this for iSupplier specific data like business classifications.
POS_VENDOR_PUB_PKG.CREATE_VENDOR
POS_VENDOR_PUB_PKG.CREATE_VENDOR_SITE
POS_VENDOR_PUB_PKG.Update_Vendor
POS_VENDOR_PUB_PKG.Validate_Vendor
POS_VENDOR_PUB_PKG.Update_Vendor_Site
POS_VENDOR_PUB_PKG.Validate_Vendor_Site
POS_VENDOR_PUB_PKG.Create_Vendor_Contact
POS_SUPP_CLASSIFICATION_PKG.add_bus_class_attr
POS_SUPPLIER_ADDRESS_PKG.assign_address_to_contact

To Update payment method code:
--------------------------------
l_vendor_rec.ext_payee_rec.default_pmt_method := 'EFT'

Important Links:
1. R12: Assigning Bank Account to Supplier -- Supplier Import [ID 466334.1]
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=R12:%20Assigning%20Bank%20Account%20to%20Supplier%20--%20Supplier%20Import&bmDocDsrc=KB&bmDocID=466334.1&from=BOOKMARK&viewingMode=1143&bmDocType=HOWTO))


2. R12: Supplier Sites Open Interface Fails to Import Records - No Data Found in Report - AP_VENDOR_ID_NULL Rejection Reason in AP_SUPPLIER_INT_REJECTIONS [ID 1311279.1]
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=R12:%20Supplier%20Sites%20Open%20Interface%20Fails%20to%20Import%20Records%20-%20No%20Data%20Found%20in%20Report%20-%20AP_VENDOR_ID_NULL%20Rejection%20Reason%20in%20AP_SUPPLIER_INT_REJECTIONS&bmDocDsrc=KB&bmDocID=1311279.1&from=BOOKMARK&viewingMode=1143&bmDocType=PROBLEM))


3. Documentation on Importing Internal and External Bank Account In R12: Bank API's [ID 948993.1]
4. R12: Supplier Site Contacts Open Interface Import REP-4 - Inconsistent Data Entered As Compared To TCA Records [ID 1195815.1]
if it wont work, try the below:

a.    Log in to TCA Community Manager (Receivables).

b.    Navigate to Trading Community>Administration> Geography Hierarchy

c.    Query country code for US and click on “Manage Validations”

d.    Change the validation from Error to Warning.