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.