Okay, we think we solved the problem, but don't ask me why; especially since we couldn't rebreak it.

Using Oracle's SQL Developer stored procedures and functions are by default compiled for debug.

When we were esearching this problem, we were getting the problem with a duplicate entry being created where one shouldn't, logicaly thinking. Well, this morning we recompliled all the stored procedures and functions in Dev without debug. Problem fixed. Recompiled the stored procedures and functions for debug, still fixed! What?? It didn't break? WT%!?!.

Went into Test, problem existed there. Compiled all procedures and functions without debug, problem fixed.

If anyone with Oracle experience can explain this, I'm all ears and willing to learn something new.