Advertisement

10.06.2008 at 01:38AM PDT, ID: 23789754 | Points: 500
[x]
Attachment Details

Link of Lotus Notes Db and Oracle 11i on ASL and AML/AVL

Asked by numero9868 in Oracle SCM, Lotus Notes, Oracle 11.x Database

Tags: ,

Hello Oracle and Lotus Notes Experts:

We are using both software for Specs and Purchasing. Our process is to have a supplier/vendor be approved in the Parts Specs db AML (Approved Manufacturer List) of Lotus Notes before we can add the vendor in Oracle ASL (Approved Supplier List).

The Purchasing policy is to place PO only to suppliers which are in AML and before you can place PO in Oracle, buyer needs to add the vendor in Oracle ASL.

However most of hte time, buyer cannot everytime check in Lotus Notes PArts Specs DB if the suppliers is in AML or not.

So our issue here is we want to have a link between Lotus Notes and Oracle. My idea is to have Oracle view the approved suppliers in AML of the parts that are in Lotus Notes db for the particular part number .

I am trying to get a complete answer in this question but only the possiblity and the lead to this questions. I am sure that probably LN or Oracle knows the answer but if some members in this EE community have experiene this issue, please share your experience and what process or method did your company use to resolve this issue.

Thanks.Start Free Trial
[+][-]10.06.2008 at 07:27AM PDT, ID: 22650341

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 14-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20081112-EE-VQP-43 - Hierarchy / EE_QW_2_20070628