>You could create something like a stored procedure whose sole task is to create the record if it doesn't already exist. Then, all the processes that need the record call the SP (i.e. delegate that function to the SP). After it completes the record is guaranteed to exist.

After more research, I already had implemented the responsibility of that record creation to a task. However, one other task was still trying to create it. This works ok now. Thanks