Issue with BEFORE INSERT trigger

[gtcol]

Hi all
I've caught into strange situation here. Attached query works just fine in our Dev RAC, but just won't in our Prod RAC. We have a BEFORE INSERT trigger that takes nextval from a sequence. I've attached the query, trigger, sequence and table DDL. When I run the query it gives me
'ORA-01400: cannot insert NULL into ("USER_T"."USR_LLG_DETAIL"."LETTERID")'.

Any hints, suggestions are appreciated.

Thanks
gtcol

[gtcol]

Has nobody experienced this before?

[gtcol]

Issue here is it works fine when I hard code the value for x.MemId in ('xx','yy','zz')(ie. the output generated by the select itself) at the end. But it just doesn't work when I remove this part.

[Kamran Agayev]

It seems from the error that

1. LETTERID column of table USR_LLG_DETAIL, which belongs to user USER_T is primary key, and you want to insert NULL value in it
2. Are you getting the new id value from Sequence?

Could you please post the code (3-4 lines) of insertion?

[gtcol]

It seems from the error that

1. LETTERID column of table USR_LLG_DETAIL, which belongs to user USER_T is primary key, and you want to insert NULL value in it
2. Are you getting the new id value from Sequence?

Could you please post the code (3-4 lines) of insertion?

1. Yes. Trigger is supposed to populate it.
2. Yes
3. Attached is the script.