New API's for Suppliers in R12

Name of Package: AP_VENDOR_PUB_PKG (apvndrs.pls and apvndrb.pls) 

AP_VENDOR_PUB_PKG.Create_Vendor

This is used to create new vendors in R12

AP_VENDOR_PUB_PKG.r_vendor_rec_type

If the TCA Party ID is provided in record type, the system will validate and create the new record in AP_SUPPLIERS else system calls TCA API to create API then create records in AP_Suppliers

AP_VENDOR_PUB_PKG.Update_Vendor_Public

Use to update vendor in R12

 AP_VENDOR_PUB_PKG.Create_Vendor_Site

 This is the new API to create new vendor sites in Release 12.

AP_VENDOR_PUB_PKG.Update_Vendor_Site_Public

        This is the new API to update Vendor Sites in Release 12.

AP_VENDOR_PUB_PKG.Create_Vendor_Contact

        This is the new API to create new vendor site contacts in Release 12. 

AP_VENDOR_PUB_PKG.Update_Vendor_Contact_Public

        This is the new API to update Vendor Contacts in Release 12.

 

CONCURRENT PROGRAMS IN R12 SUPPLIERS

       APXSUIMP - SUPPLIER OPEN INTERFACE IMPORT 

Supplier Open Interface Import program is extended to create Parties in TCA when creating the suppliers based on the information in AP_SUPPLIERS_INT. If records are populated in the IBY External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts.


 APXSSIMP -- Supplier Sites Open Interface Import Supplier Sites Open Interface Import program is extended to create Locations, Party Sites, and Party Site Uses in TCA based on the information provided in AP_SUPPLIER_SITES_INT. If records are populated in the Payments External Payee Accounts table, then the program will call the necessary APIs from Oracle Payments to create the Supplier Bank Accounts for the site. 

APXSCIMP -- Supplier Site Contacts Open Interface Import Supplier Sites Contacts Open Interface Import program is extended to create Person Parties, Contact Relationships, Org Contacts, Contact Party Sites, and Contact Points in TCA based on the information provided in AP_SUPPLIER_SITES_INT. 

New Tables in R12 Suppliers

AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS
AP_SUPPLIER_INT_REJECTIONS

Suppliers in R12

Supplier information in EBS is basically defined using three things

1. Suppliers
2. Supplier Locations/Sites
3. Supplier Contacts


R11 Vs. R12


R11

Suppliers is stored in PO_Vendors
Supplier Locations/Sites PO_Vendor_Sites_All
Supplier Contacts are stored in PO_Vendor_Contacts

R12

In R12,

PO_Vendors changed as AP_Suppliers
PO_Vendor_Sites_All is changed as AP_Supplier_Sites_All
PO_Vendor_Contacts is changed as AP_Supplier_Contacts


     The supplier sites table will store the Site account attributes per Operating Unit,
     which will default into transactions. Going forward, supplier site creation will involve
     either selecting an existing location for the supplier or creating a new location in HZ_LOCATIONS.
     The user will then have to select the Operating Unit based on the security profile,
     and enter the site attributes as they are entered today.




The existing Suppliers tables are obsoleted and renamed as: 
PO_Vendors_OBS
PO_Vendor_Sites_All_OBS and
PO_Vendor_Contacts_OBS


To minimize impact on other products, views are provided with names

PO_Vendors
PO_Vendor_Sites_All
PO_Vendor_Contacts