Vendor conversion/interface

Vendor Conversion interface, askHareesh blog for Oracle Apps

Vendor conversion/interface

This interface is used to import suppliers, supplier sites and site contacts into Oracle applications.

Pre-requisites:
  • Payment terms
  • Pay Groups
  • CCID
  • Supplier classifications
  • Bank Accounts
  • Employees (if employees have to set up as vendors)
Interface tables:
  • AP_SUPPLIERS_INT
  • AP_SUPPLIER_SITES_INT
  • AP_SUP_SITE_CONTACT_INT
Base Tables:
  • PO_VENDORS
  • PO_VENDOR_SITES_ALL
  • PO_VENDOR_CONTACTS
Interface programs:
  • Supplier Open Interface Import
  • Supplier Sites Open Interface Import
  • Supplier Site Contacts Open Interface Import
Validations:
  • Check if vendor already exists
  • Check if vendor site already exists
  • Check if site contact already exists
  • Check if term is defined.
Important Columns:
Some important columns that need to be populated in the interface tables:
AP_SUPPLIERS_INT:
  • VENDOR_NUMBER
  • VENDOR_NAME
  • VENDOR_TYPE
  • STATE_REPORTABLE
  • FED_REPORTABLE
  • NUM_1099,
  • TYPE_1099
  • PAY_GROUP_LOOKUP_CODE
  • VENDOR_ID is auto generated.
AP_SUPPLIER_SITES_INT:
  • VENDOR_SITE_ID
  • ORG_ID
  • VENDOR_SITE_CODE
  • INACTIVE_DATE
  • PAY_SITE
  • PURCHASING_SITE
  • SITE_PAYMENT_TERM
  • ADDRESS1
  • ADDRESS2
  • ADDRESS3
  • CITY
  • STATE
  • COUNTRY
  • ZIP
  • PH_NUM
  • FAX_NUMBER
  • TAX_REPORTING_SITE_FLAG
AP_SUP_SITE_CONTACTS_INT:
  • VENDOR_ID
  • VENDOR_SITE_ID
  • FIRST_NAME
  • LAST_NAME
  • AREA_CODE
  • PHONE
  • EMAIL
  • ORG_ID

*/