Hello there!
I’m trying to build a custom event that triggers after a new object is created and it updates a field value of this new object.
However, when the system trigger the event it doesnt update the new object field, it does on the previous object.

This event has the following action

SQL:
UPDATE FISCAL_NOTE_TEMP_TAB
SET OBSERVATION2 = 'seu texto aqui teste sem função'
WHERE FISCAL_NOTE_ID = (
SELECT MAX(FISCAL_NOTE_ID)
FROM FISCAL_NOTE_TEMP_TAB
)
Any ideas of how to build/ fix this?