Should any PeopleSoft installation require on-going daily DB scripts to resolve "issues"?

Question

I have very little PeopleSoft experience but have been put in a position to support an install. This question could straddles serverfault but is certainly developer oriented.

On a daily basis, we have a PeopleSoft "developer" who writes scripts to fix records/journal entries/approval status etc. To me this screams "bad install" and botched customizations. Is this normal? Is it best practice to have an employee having to write scripts daily just to keep things running?

Note: there is no fraud happening here, he has the full approval of the accounting department when doing this.

Answer 1

It is unlikely that it is the installation. Likely causes:

1. Bad customization
2. Missing patches
3. Bugs in the delivered code

If you only have one admin, though, and you have only one developer, I would be shocked to hear that there is much in the way of custom code.

Back to the question: It is not normal to need to do SQL updates regularly to fix data. Yes, it happens, but not too often. It is also possible that the end users could fix it from the application, but do not for some reason.