This content has been marked as final. Show 2 replies
th enegative sequence number is only kept until the record is committed to the database. Until then its only available when you query memory based (not SQL based, which is the default). So you may want to try a view criteria and set it to memory queries to check if you can query for the negative ID
Frank, I tried both memory and database modes, with the same result.
the issue is that the following in the subquery's WHERE clause should in theory filter out the new record with the negative number. For some reason it's not doing so - the inequality filter works fine with a positive number, but is ignoring the negative number generated for the pre-committed phase:
The column is a Number, as is the bind variable.
(MESSAGE_NUMBER != :v_MsgNum)
Thanks for your help!