Supplier Sites Payment information in R12

            Supplier Site payment information in R12 will not be there in the AP supplier base table AP_SUPPLIER_SITES_ALL. In R12 Payments/Payment methods are overtaken by IBY (Payments). Payment method code in R12 is stored in IBY_PAYMENT_METHODS.PAYMENT_METHOD_CODE The default payment method for supplier sites are now located in the IBY_EXT_PARTY_PMT_MTHDS table. Below is a query that will return a list of all suppliers, supplier sites and their payment methods.

SELECT         ieppm.ext_party_pmt_mthd_id,

     s.vendor_name,

     ss.vendor_site_code,

     ieppm.payment_method_code,

     eppm.primary_flag,

     ieppm.inactive_date,

     ss.org_id,

     s.vendor_id,

     ss.vendor_site_id

FROM ap_supplier_sites_all ss,

            ap_suppliers s,

            iby_external_payees_all iepa,

            iby_ext_party_pmt_mthds ieppm

WHERE sup.vendor_id = assa.vendor_id

AND      assa.pay_site_flag = ‘Y’

AND      assa.vendor_site_id = iepa.supplier_site_id

AND      iepa.ext_payee_id = ieppm.ext_pmt_party_id

AND      ((ieppm.inactive_date IS NULL)or (ieppm.inactive_date > sysdate))

Supplier Extract from R12

        I had a requirement where customer had their financial modules in 11i and had the other modules in R12.They also had the new modules like TCA and so on. For operations like Invoices, Receipts from AP they need the Supplier information. I was allocated to do an interface between the 11i and R12 to load the supplier Extract from R12 to Apps financials 11i.

      Need to extract the details of the Supplier, Supplier Sites and the Supplier contacts. While doing the research about it in the internet, I got some useful info about R12 suppliers.

     The Supplier information in the 11i apps will be stored in the Purchasing module. The tables used are PO_VENDORS, PO_VENDOR_SITES_ALL and PO_VENDOR_CONTACTS.

      In R12 the suppliers were merged into the Trading Community Architecture (TCA). So Supplier information will be stored in the TCA tables and AP Suppliers tables. The tables are AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL and AP_SUPPLIER_CONTACTS.

      To maintain compatibility Oracle has made the R11 tables to views. So PO_VENDORS, PO_VENDOR_SITES_ALL and PO_VENDOR_CONTACTS views also can be used in R12. Using Views is one of the good approaches. Coz, Base table will store the values as ID’s. But in views the logic to return the code for the IDs will be written in default.

       I used these views to retrieve most of the extract data. Supplier site payment details in R12 are stored in a different table. Will share that in my next post.