SUPPLIER CONTACT INFORMATION

Summary

Loading of duplicate Firstname and Lastname of a Supplier contact

Content

When supplier contact information is converted to Oracle, there needs to be a firstname and lastname in order to convert the phone numbers.

 

In our legacy system we have three different places where we have contact numbers but only one place where there is a name.

Not all contact numbers have names associated with it.  

 

The SI has suggested and has programmed the conversion to fill "fname" and "lname" where there is no name in the legacy system associated with a phone number.

 

The DOE was told yesterday by the SI that if a Supplier has multiple same fname and lname that the Supplier conversion transaction(s) will error out when the conversion tables are loaded. Only