Oracle WebADI is a commonly used tool for quickly uploading a vast array of data into a Project.  Having spent time and effort creating the WebADI data, for the thousands of ADI users, the sad red face not only represents failure to load Project critical data but also represents frustration.  This frustration is sometimes caused by poor data integrity which can be avoided by adopting best practice approaches and communicating these to the user community to ensure consistency. 

An understandable mistake

I witnessed one such issue recently at a client site where on the face of it (excuse the pun), an “understandable” mistake led to much user annoyance.  Whilst attempting to load financial plan data into the Project Management application using Web ADI, a user kept receiving the error message: “An error has occurred while running an API import”.  

Read the rest of this entry »