Hi
Under Oracle APEX 24.2.11, I have an interactive grid “Référents de cette crise” p.39 on a form based on a table AD_CRISE_REFERENT. When I add a new line to this IG and save it I have a message saying that the data is saved successfully, but the new line added dot not appear on the IG after this message. I have checked the table, no data is inserted. The debug show this:
0,013440,00118Rows processed successfully, fetch inserted/updated rows4
0,014630,00005Generated Component SQL Query:4
0,014670,00412select i.*
from (select "ID","ID_CRISE","ID_REFERENT","APEX$L1041577808912890920","ID_ROLE","APEX$L1041577736452890919"
from(select /*+ qb_name(apex$inner) */d."ID",d."ID_CRISE",d."ID_REFERENT" "ID_REFERENT",nvl("APX$LOV3"."D", d."ID_REFERENT")"APEX$L1041577808912890920","APX$LOV3"."R" "APX$LOV3_RETURN",d."ID_ROLE" "ID_ROLE",nvl("APX$LOV5"."ROLE", null)"APEX$L1041577736452890919","APX$LOV5"."ID" "APX$LOV5_RETURN" from(select x.* from "AD_CRISE_REFERENT" x
where(ID_CRISE = :P39_ID
)
)d,(select "D","R"
from(select a.id as r,
a.nom || ' ' || a.prénom || ' - ' || a.EMAIL || ' - ' || a.id || ' - ' || b.FIABILITE as D
from ad_benevole a
left join ad_notation b
on a.id = b.benevole
where a.membre_actif = 'Oui'
order by a.nom
)i
)"APX$LOV3" ,(select "ROLE","ID"
from(select x.* from "AD_ROLE" x
)i
)"APX$LOV5" where "APX$LOV3"."R"(+) = d."ID_REFERENT" and "APX$LOV5"."ID"(+) = d."ID_ROLE"
)i
)i
where "ID"=:apex$pk14
0,018800,00035bulk fetching is NOT supported for this query4
0,019150,00011< APEX_APPLICATION_PAGE_REGIONS Référents de la Crise
Best regards.