Many thanks for the very detailed response. In principle this looks fine. Can you explain me how you solved the issue that Sonata has a less rigid vendor selection for raw materials for domestic products than for raw materials for international products?
Do you solve it with the Item code, as we discussed when I was in the city?
E.g. Something like Acetylcholix for international products gets the Item code 1001 and Acetylcholix for domestic products gets the item code 2001? (i.e. it is basically the same raw material. The only differences are the target product and therefore the quality requirements).
Vendor selection process at Sonata is as follows:
1. Procurement team get in touch with the vendors for the sample material – Outside system activity
2. Procurement team get the samples and handover it to Quality Dept - Outside system activity
3. Quality test the samples and give the status as Approved / Not approved – In Oracle system
4. Based on the feedback provided by Quality and the decision made by Procurement team, Supplier is declared as ’Approved Supplier’ - Outside system activity
5. Purchasing team assigns the Items to Approved suppliers in ‘Approved Supplier List’ screen in oracle. - In Oracle system
This completes the vendor selection process. Approved supplier list being the standard Oracle functionality; it’s not mentioned in the To Be process.
We have already shared the ‘ASL’ template with Sonata team. Attached here for your reference.
Screenshots of the how items are assigned to the Supplier is given below:
Approved Supplier: Status is Approved and disabled checkbox is not ticked.

Unapproved Supplier: Disabled checkbox is enabled. Or you can change the status to ‘Debarred’.


Hope this clarifies all your doubts.
Do you solve it with the Item code, as we discussed when I was in the city?
E.g. Something like Acetylcholix for international products gets the Item code 1001 and Acetylcholix for domestic products gets the item code 2001? (i.e. it is basically the same raw material. The only differences are the target product and therefore the quality requirements).
Vendor selection process at Sonata is as follows:
1. Procurement team get in touch with the vendors for the sample material – Outside system activity
2. Procurement team get the samples and handover it to Quality Dept - Outside system activity
3. Quality test the samples and give the status as Approved / Not approved – In Oracle system
4. Based on the feedback provided by Quality and the decision made by Procurement team, Supplier is declared as ’Approved Supplier’ - Outside system activity
5. Purchasing team assigns the Items to Approved suppliers in ‘Approved Supplier List’ screen in oracle. - In Oracle system
This completes the vendor selection process. Approved supplier list being the standard Oracle functionality; it’s not mentioned in the To Be process.
We have already shared the ‘ASL’ template with Sonata team. Attached here for your reference.
Screenshots of the how items are assigned to the Supplier is given below:
Approved Supplier: Status is Approved and disabled checkbox is not ticked.

Unapproved Supplier: Disabled checkbox is enabled. Or you can change the status to ‘Debarred’.


Hope this clarifies all your doubts.