My trigger would not work on apex. Idk why.
CREATE OR REPLACE EDITIONABLE TRIGGER "BI_ITEM"
before insert on "ITEM"
for each row
begin
if :NEW."ITEM_ID" is null then
select "ITEM_SEQ".nextval into :NEW."ITEM_ID" from sys.dual;
end if;
end;
compilation with error message.