Supplier Interface in Oracle Apps R12

There are three interface tables in oracle apps Supplier Interface.

1] AP_SUPPILERS_INT
2] AP_SUPPLIER_SITES_INT
3] AP_SUP_SITE_CONTACTS_INT

Supplier Interface Programs:

1]  Supplier Open Interface Import
2]  Supplier Sites Open Interface Import
3]  Supplier Site Contacts Open Interface Import

1] AP_SUPPLIERS_INT

This is the Open interface table for Supplier used to store Supplier header information. The columns mapped to corresponding AP_SUPPLIERS table.

‘Supplier Open Interface Import’ request is used to import Supplier Header Information into Oracle.

Mandatory Columns:
            VENDOR_INTERFACE_ID  è AP_SUPPLIERS_INT_S.NEXTVAL [ Unique Identifier]
            VENDOR_NAME                 è Supplier Name

Other Important Columns:
            VENDOR_TYPE_LOOKUP_CODE è Supplier Type [e.g. Company etc]
            SUMMARY_FLAG                           è Key Flexfield Summary Flag
            ENABLED_FLAG                            è Key Flexfield Enable flag
            NUM_1099                                         è Tax identification number
            INVOICE_CURRENCY_CODE     è Invoice Currency Identifier
            TERMS_ID                                        è Payment Terms Identifier
            SEGMENT1                                      è Vendor Number

2] AP_SUPPLIER_SITES_INT

This is the Open interface table to import supplier sites information. The columns mapped to corresponding AP_SUPPLIER_SITES_ALL table.

‘Supplier Sites Open Interface Import’ request is used to import Supplier site Information into Oracle.

Mandatory Columns:
            VENDOR_SITE_INTERFACE_ID   è AP_SUPPLIER_SITES_INT_S.NEXTVAL [Unique Identifier]
            VENDOR_SITE_CODE                  è Supplier Site Name
            VENDOR_ID                                                è Vendor ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.

Other Important Columns:
            ADDRESS_LINE1                è First Line of Address
            ADDRESS_LINE2                è Second Line of Address
            ADDRESS_LINE3                è Third line of Address
            CITY                                       è City Name
            STATE                                   è State Name
            COUNTRY                            è Country Name
            ZIP                                          è Postal Code
            PHONE                                  è Phone Number
            FAX                                        è Fax Number
            EMAIL_ADDRESS              è Supplier Site URL
            PURCHASING_SITE_FLAGè To indicate purchasing allow from this site [Y/N]
            RFQ_ONLY_SITE_FLAG   è To indicate quotations allow from this site [Y/N]
            PAY_SITE_FLAG                è To indicate payable invoice allow for this site [Y/N]
            INVOICE_CURRENCY_CODEè Invoice Currency Identifier
            TERMS_ID                            è Payment Terms ID

3] AP_SUP_SITE_CONTACT_INT:

This is Open interface table for supplier site contacts. The columns mapped to corresponding AP_SUPPLIER_CONTACTS table.

Supplier Site Contacts Open Interface Import’ request is used to import Supplier site Contacts Information into Oracle.

Mandatory Columns:
            VENDOR_CONTACT_INTERFACE_ID è AP_SUP_SITE_CONTACT_INT_S.NEXTVAL [Unique Identifier]
            VENDOR_SITE_CODE                           è Supplier Site Code

Other Important Columns:
            VENDOR_ID                                        è Vendor_ID created in AP_SUPPLIERS table after submission of Supplier Open Interface Import request.
            VENDOR_SITE_ID                 è Vendor_Site_ID created in AP_SUPPLIER_SITES_ALL table after submission of Supplier Sites Open Interface Import request.
            PREFIX                                     è Title e.g. [Mr, Mrs, Doctor etc]
            FIRST_NAME                           è Contact First Name
            MIDDLE_NAME                      è Contact Middle Name
            LAST_NAME                                        è Contact Last Name
            AREA_CODE                                        è Area Code of Contact phone number
            PHONE                                      è Contact phone number
            FAX_AREA_CODE                  è Area Code of Contact facsimile number
            FAX                                            è Contact facsimile number     

Validation during Supplier Import using interface:

1] AP_SUPPLIER_INT.VENDOR_NAME
            Validation for duplicate Supplier Name in AP_SUPPLIERS table.

2] AP_SUPPLIER_INT.VENDOR_TYPE_LOOKUP_CODE
            Validations for valid Supplier Type in PO_LOOKUP_CODES table for LOOK_TYPE as ‘VENDOR TYPE’.

3] AP_SUPPLIER_INT.SEGMENT1
            Validation for duplicate Supplier Number in AP_SUPPLIERS table.

4] AP_SUPPLIER_SITES_INT.VENDOR_SITE_CODE
            Validation for duplicate Supplier Site Name in AP_SUPPLIER_SITES table.

5] AP_SUPPLIER_SITES_INT.COUNTRY
            Validation for country code in FND_TERRITORIES_VL table.

AP_SUPPLIER_INT_REJECTIONS table contains suppliers, sites, contacts rejections information.