One of the main reasons web developers (like me) shy away from placing business logic in the database is the difficulty of testing it. One of those problems is how to test time dependent code - monthly billing cycles, repeat reminders, interest payments, etc. Code that's usually very important to get right. (And tends to run unattended at 2am.)
Oracle does offer a way to set the internal system clock to a fixed time for testing.