AP Suppliers in R12

I got a chance to work on R12 AP Suppliers. I am sharing the knowledge which I have gained when I tried to learn about supplier in payables. A supplier will have 3 main categories of information, the supplier detail, Site information and the contact information. These will be maintained in three separate tables. In R12 there are three base tables which will maintain the information about the suppliers.

In R12 the Supplier can be of main two types, the standard supplier and the employee supplier. The standard supplier is who supply some goods to the organization. The employee supplier is the employee of the organization who claim his money from the company for the service or travel he made for the company in iExpence module.

The tables are

AP_SUPPLIERS

AP_SUPPLIER_SITES

AP_SUPPLIER_CONTACTS

There are three related interface tables

AP_SUPPILERS_INT

AP_SUPPLIER_SITES_INT

AP_SUP_SITE_CONTACTS_INT

In 11i there where PO_VENDORS, PO_VENDOR_SITES, PO_VENDOR_CONTACTS table which was doing the same work which these supplier tables do. But in R12 these table has been changed to views to solve R12 and 11i compatibility. SO these tables also can be used to do the operations. Using of views for selecting the data is a good practice coz this will avoid the id logics in our code. The base tables will be stored with ids.

R12 version has a new module called TCA (Trading Community Architecture) which deals all the suppliers as parties. This module also makes an entry when a supplier is added.TCA tables also maintain separate tables for parties, Sites and contacts.

The suppliers from the flat files can be loaded in to the system. This can be done by running the oracle supplier interface programs.

Supplier Interface Programs:

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

These programs will load the supplier information from the interface tables to the base table.

AP_SUPPLIER_INT_REJECTIONS table contains suppliers, sites, contacts rejections information.