SUPPLIER Interface

 Links

Supplier Interface in Oracle Apps R12

Managing Supplier Import and Source Systems

Supplier Import R12

Creating R12 Supplier Bank Accounts

AP_VENDOR_PUB_PKG.Update_Vendor.sql

API/Script to update Supplier and Supplier Sites Oracle Apps R12

Oracle R12 Employee as Supplier

Employee as a Supplier in Oracle Payable R12

Loading External Supplier Banks, Branches and Accounts

 R12 Supplier Bank Loading Thru API
Oracle R12 – Some good Question on Supplier – Bank Setups

 Oracle Supplier Tables:

This is Supplier Interface Program to load the data for the Oracle Tables:

1.      AP_SUPPLIERS

2.      AP_SUPPLIER_SITES_ALL

3.      AP_SUPPLIER_CONTACTS

Oracle Supplier Interface Table

To load data, interface tables will be used:

1.      AP_SUPPLIERS_INT

2.      AP_SUPPLIER_SITES_INT

3.      AP_SUP_SITE_CONTACT_INT

Minimum columns to be populated for suppliers interface:

Table AP_SUPPLIERS_INT

1.       Vendor_ interface_ id => ap_suppliers_int_s.next_val

2.       summary_flag=>set to y

3.       enabled_flag=>set to y

4.       vendor_name

5.       segment1=>vendor number

6.       terms_id/terms_name

7.       invoice_currency_code

Table AP_SUPPILER_SITES_INT

1.       vendor_site_interface_id=> ap_supplier_sites_int_s.nextval

2.       vendor_interface_id =>ap_supplier_sites_int_s.nextval

3.       vendor_site_code

4.       org_id

5.       vendor_id

6.       address_line1

7.       terms_id/terms_name

8.       invoice_currency_code

9.       country

Table AP_SUP_SITE_CONTACT_INT

1.       vendor_interface_id =>ap_supplier_sites_int_s.nextval

2.       vendor_contact_interface_id=>AP_SUP_SITE_CONTACT_INT_S.NEXTVAL

3.       vendor_site_code

4.       org_id

5.       vendor_site_id

6.       vendor_id

7.       last_name

Note: if you want to populate URL or Email then make sure they are in correct format or oracle rejects these data. The data inserted via this interface are automatically populated into “HZ_PARTIES” table.

Steps to Load the Data:

1.       Define the Executable and Concurrent Programs

2.       Create the Stage Tables as XXAP_SUPPLIERS_INT_STG, XXAP_SUPPLIER_SITES_INT_STG, XXAP_SUP_SITE_CONTACT_INT_STG.

3.       Create Package “XXEDB_AP_SUPPLIERS_INTERFACE”, Validate the Stage Tables and insert into the Suppliers interface tables.

4.       Run the Oracle’s Open Supplier Standard Interfaces Programs in "Payable Manager" Responsibility.

a.       Supplier Open Interface Import

b.      Supplier Sites Open Interface Import

c.       Supplier Contacts Open Interface Import

5.       View the Rejection Records, “AP_SUPPLIER_INT_REJECTIONS” Table

------------------------------------------------------------------------------------------------------------------
Stage Table And Package Script

AP SUPPLIER SCRIPT DETAIL