1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can any one give me the detail business scenario How Supplier Merge is useful

Discussion in 'Oracle Financials' started by asha, Jun 27, 2014.

  1. asha

    asha Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi Team,

    Need few examples of real time ,How the Supplier Merge is useful
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi Asha,

    The Supplier Merge process can be used to fulfill the following requirements:

    1. Merge duplicate suppliers into a single, consolidated supplier.
    2. Merge transactions within the same supplier from one supplier site to a different supplier site.
    3. 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.
     

    Attached Files:

    asha likes this.
  3. asha

    asha Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Hi Rajen,

    Can you please provide tables affected during supplier merge other than

    AP_INVOICES_ALL

    -AP_SUPPLIERS

    -AP_SUPPLIER_SITES_ALL

    Thanks
    Asha
     
  4. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Asha,

    The following table will effect at the time of Supplier Merge.

    AP_DUPLICATE_VENDORS_ALL

    AP_DUPLICATE_VENDORS_V


    Regards
    Sambasiva Reddy.K
     
  5. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Hi Asha,

    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.
     
  6. asha

    asha Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    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