Okay, my bad. I found that in the ClientInfo BI trigger I was assigning a new CLIENT_ID value from the generator, even if it was assigned. This caused the FK problem.

Thanks for your time Helen.

Ed Dressel