APEX

Under Oracle APEX 24.2.11, I try to affect dynamycally the value the item P24_ID_PARTICIPATION2 when the item P24_CREE_PAR type lov is modified. Hi also want the item P24_ID_PARTICIPATION is set dynamically when I change the value of of the LOV item P24_BENEVOLE is changed. Both are columns the table AD_TACHE with this select :

select TITRE,
      DESCRIPTION,
      BENEVOLE,
      PROJET,
      DATE_DEBUT,
      DATE_FIN,
      COMMENTAIRES,
      DATE_CREATION,
      DATE_MODIFICATION,
      ID,
      TACHE_VALIDEE,
      TACHE_TERMINEE,
      MODIFIE_PAR,
      CREE_PAR,
      DRH,
      DATE_REELLE_FIN,
      MIMETYPE,
      CREATED_DATE,
      FILENAME,
      FILE2,
      PAYS,
      MAIL_DRH, ASSISTANT, URL_SERVEUR, ID_PARTICIPATION, ID_PARTICIPATION2
 from AD_TACHE

ID_PARTICIPATION is well well populated in the table AD_TACHE :

But ID_PARTICIPATION2 is not corresponding to the value displayed on the form :

Default value of P24_ID_PARTICIPATION is :

select ID FROM AD_NOTATION WHERE BENEVOLE = :P24_BENEVOLE;

Default value of P24_ID_PARTICIPATION2 is :

select ID FROM AD_NOTATION WHERE BENEVOLE = :P24_CREE_PAR;

I don't understand why the value of ID_PARTICPATION2 is wrong. There are not DAs. I tried without success.

Best regards.