Hi,
I have a form with a DML process. When I try to create a new record I get error "ORA-01400 cannot insert null into "SIVOA"."C_VARIABLE"."CLEF_VAR". The primary key is CLEF_VAR. It is populated by an item P62_CLEF_VAR. This item is calculated by a process.The item is calculated well. When I look at the debug window I can see that the insert statement do NOT contains the primary key "CLEF_VAR":
"- error_statement: begin begin insert into "C_VARIABLE" ( "REF_VAR","CLEF_EQUIP","LIBELLE") values (:DML_BV0001,:DML_BV0002,:DML_BV0003); end;
end;"
Or it should contain the primary key CLEF_VAR.
I have been recreating the DML process again and the error still persists.
How to fix this ?
Regards.