Changes in R12 Accounts Payables:
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
- 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.
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
|
||
|
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