Thanks for the replies guys,
I will consider these options and see what I can do, It seems to me that any path I go the concurrency will be a problem..
@gilamonster Looking forward for that blog.
Using sequences avoids the concurrency issue.
I see, I will try this. Also is it easy to setup the actual value of a sequence? For example the Au_wh0_seq to 33245 ?