Discussion in 'Oracle Financials' started by asha, Jun 27, 2014.
Need few examples of real time ,How the Supplier Merge is useful
The Supplier Merge process can be used to fulfill the following requirements:
Merge duplicate suppliers into a single, consolidated supplier.
Merge transactions within the same supplier from one supplier site to a different supplier site.
Merge all transactions for a supplier into a new supplier, or you can just choose to merge unpaid invoices.
Although technically speaking, Oracle AP doesn't allow you to create two identical suppliers, you may end up with 2 "duplicate" suppliers (like, for example, in the attached slide, "ABC Corp" and "ABC Corporation").
Common sources of "duplicate" suppliers are from:
Data migration: when supplier data from an external or manual AP systems where supplier lists are maintained by various departments on stand-alone systems are compiled and migrated to EBS. Although, there is usually a data cleaning phase, we may still get "duplicates".
Supplier Creation within EBS: improper control procedures for supplier creation may also provoke this kind of situation as we may receive invoices with slight differences of Supplier Name and if the AP User responsible for entering the invoice doesn't do a proper check, he may create (or ask somebody else if he doesn't have the access) "duplicate" suppliers.
You may also have situations where you need to merge 2 different suppliers like takeover of a company and Mergers.
As for supplier sites merging, it's mostly for cases where the receivables department of the supplier is merged or centralized to another site: for ex., Division1 at Site1 having all it's finance activities shifted or merged with Head Office or with another Division2 at Site2.
Hopes this gives you an idea and matches with your needs.
Can you please provide tables affected during supplier merge other than
The following table will effect at the time of Supplier Merge.
You have already listed the main tables.
Just to add to your's and Sambasiva's above lists:
- AP_SUPPLIER_CONTACTS, AP_CHECKS_ALL, AP_RECURRING_PAYMENTS, AP_HISTORY_INVOICES_ALL
- PO_HEADERS_ALL, ...
and the lists extends when it comes to the possible transactions which are being updated.
You'll have to dig into the Apps AP APIs to get the exhaustive list.
Thanks for the input
AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge calls to several other products ,can i get any techical documents on the Supplier Merge regarding the forms and packages