You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Avoid selection of Duplicate Suppliers

Accepted answer
edited Nov 23, 2020 8:51AM in Sourcing 2 comments


Hi all,

My case is as following:

Buyer searches on Purchase Categories to select Suppliers from a list to add to the RFQ.

First he searches on Category X
50 Suppliers are eligible and he adds all of them

Secondly he searches on Category Y
Another 40 Suppliers are eligible and he adds all of them


1) For all 90 suppliers, he would need to populate the Supplier Site field because it's not auto-populated if there is only 1 site (Idea is already pending for this:

2) If the Supplier base covering those 2 Categories (X and Y) overlap, you're adding duplicate Suppliers. For example 20 Suppliers overlap in both categories. You'll be going through a list of 90 Suppliers to then get a Error message from Oracle stating that for these 20 Suppliers there's already a unique record in. You'll need to go through the entire list and find those that are a duplicate and delete.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!