AP Suppliers in R12

Changes in R12 Accounts Payables:
  • Suppliers have gone to self-service instead of supplier form.
  • The suppliers objects have moved from AP product to TCA (Trading Community Architecture) DataModel.
  • So that Supplier information does not stored in PO_VENDORS Table.
  • 3 new tables have been introduced.
  • AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, AP_SUPPLIER_CONTACTS
  • Even then your customizations can still work as there are views created with names of PO_VENDORS, PO_VENDOR_SITES_ALL and PO_VENDOR_CONTACTS.
List of few important HZ Tables that are affected when a new supplier is added:


Table Name
Description
HZ_PARTIES
Master table along with AP_SUPPLIERS instead of PO_VENDORS
HZ_PARTY_SITES
Master table for supplier sites along with AP_SUPPLIER_SITES_ALL instead of PO_VENDORS_SITES_ALL
HZ_LOCATIONS
Contains the party sites information

HZ_PARTY_USG_ASSIGNMENTS
Stores party usages

HZ_ORGANIZATION_PROFILES
Captures additional Supplier information, e.g. credit scoring details of Supplier or the Number of Employees working in Supplier Organization
IBY_EXTERNAL_PAYEES_ALL
Captures Payment related details of the Supplier

POS_SUPPLIER_MAPPINGS
It holds the mapping between the AP_SUPPLIERS.VENDOR_ID and HZ_PARTIES.PARTY_ID

See the diagram below for how Supplier/Sites Mappings to TCA Objects.



Creating a supplier in R12 is different from 11i.

Steps to create supplier


*/