Teachers Give ERP Implementations Failing Grades
theodp writes "Nine months after the Los Angeles Unified School District launched SAP HR and Payroll as part of a larger $132M ERP rollout, LAUSD employees are still being overpaid, underpaid or going unpaid. In June, about 30,000 paychecks were issued with errors, falling somewhat short of the Mission Statement 'to effectively deliver services to meet the payroll needs of all District employees serving our students.' Meanwhile, a $17M PeopleSoft-based payroll implementation has been making life miserable for Chicago Public Schools teachers and staff since last April, including June retirees who were stiffed for more than $35M. It's been a bad computer year for CPS staff, who also had to contend with a new $60M system that wasn't up to the task of taking attendance."
In my experience, this kind of thing is typical.
It's almost a rule that the more expensive the software, the more likely it is to really and truly SUCK.
It's also a rule that the bigger the company/organization/school district/whatever, the less likely it is that "technology" purchasing decisions are made by someone who actually HAS A CLUE about technology. The reason being, of course, that technology is too expensive to let the "tech" people get involved with the purchasing process.
Like I said, this is all par-for-the-course in the American corporate world. And school districts/government organizations are even WORSE.
One of the main problems facing these ERP systems is that they try to be far too generic. Site-specific functionality is jammed into the overall framework in the form of modules. Unfortunately, business logic is often very complex, and so it doesn't always fit well into these modules. This can lead directly to hackish attempts to circumvent the limitations imposed by the ERP modules system, which often leads directly to faulty software.
Another problem affecting lower-end ERP solutions is the use of data abstraction layers like Hibernate. These layers separate the application developers from the databases that are actually storing the data being manipulated by the ERP system. Since the developers tend to now avoid writing SQL statements, they lose sight of the real relationships between the data stored within the database tables. Losing sight of these relationships means that the developers often take obtuse, roundabout ways to getting to data through the data abstraction layer, when the same data could be obtained in a few lines of SQL.