1 of 1 people found this helpful
The only time that I've seen name mismatches with queries similar to the ones that you have provided have been:
- when the common and partitioned supplier names did not match due to name changes in an ERP-backend system that are not synced with Ariba
- when multiple partitioned suppliers are available for the common supplier (for multiple partitions) and one of the partitioned suppliers has a vastly different name (for example, partitioning by region could result in the regional supplier with a different name than the parent common supplier)
Have you open a ticket with Ariba Customer Support to help troubleshoot and deep-dive into the issue?
1 of 1 people found this helpful
Good observation and advice. I would like to further add that, in this case, the suppliers (due to wrong/invalid System ID) on the catalog items, could be out of sync with the actual suppliers in the system. Hence, in some cases, the Description.CommonSupplier field is null.
Assuming the supplier data has been updated (via file channel) or synchronized (with an ERP system), I would suggest a relook at the System IDs of the catalogs and correct them (if required) and reimport the catalogs.
Thanks for the insight! We did open a ticket with Connect that they have since closed because they couldn't replicate the issue. I was hoping that someone else may have seen some similar inconsistencies in the data that might indicate that this was due to a defect.
We have a great example of this issue - this particular order is one of only two affected orders for this particular supplier out of 1,086 total orders. There was an order that was sent out the day before and one that was sent out only one minute after and neither of them were affected. The "bad" order has three line items. All of LineItem.Supplier fields were set appropriately. However, one of the LineItem.Description.CommonSupplier fields was left null, and the other two were set for totally different suppliers (different from each other and different from the LineItem.Supplier). They were all non-catalog items.
We have only one partition and we have only one Supplier per CommonSupplier record.
I was unable to reproduce on several test and demo instances as well. I see a few options available:
- Wait and see if anyone else has additional feedback that could be shared
- Post detailed information directly to Exchange and see if anyone has run into this particular issue (using the additional detail to potentially review on their system) -- NOTE: if any of the information is sensitive, you may need to either scrub the data or ignore this option
- Schedule a session with your Customer Engagement Manager so that we can look at the customizations, catalog setup, supplier setup, etc. and talk though the impact of the issue
I know this isn't a blockbuster answer, but I think a deeper dive of the issue (with more data) is needed, especially considering that we've not been able to reproduce this on out-of-the-box configurations.
Message was edited by: Michael Odom
That is a great suggestion...I will follow-up with our CEM. I'm not sure if I follow your second option, though. How can I post "directly to Exchange"....I thought that is what I did. Do you mean in some other group? The queries that I posted above should provide results to indicate if other clients are affected - rows are only returned if there are mismatched or null CommonSuppliers on the Line Item description.
Regarding the second option ("posting info directly to Exchange") -- what I meant by that was posting all of that deep-dive information directly to the forum (supplier data, screenshots, results from your queries, etc). I wouldn't recommend this approach (as it exposes your companies data to anyone on Exchange unless you scrub it substantially), but it would be an option if you wanted to keep the entire community up to date on the details of the review.