Hi everyone
I am using APEX 20.2 and users discoverred a strange issue :
My application have a CONF button with several DA
I use Javascript expressions as Client Side Condition So only 1 DA can be executed at a time depending of the value of 1 field
Issue is generated on “Conf Line OK” DA
This DA submit the page
I added a PL/SQL DA to store the timestamp using a function
And I saw the DA was activated twice, at and interval of 500ms
The second launch generated an error (ORA-00001) which seems logic as line has already been saved by the first launch
But due to this error on the second submit, page doesn't refresh with the first successfull submit
And so user is unable to continue
This error seems randomly appears, some days it doesn't happens at all and some others day it can happens every 5 minutes…
So it is very difficult to reproduce it;
I expected the “Show Processing” tick box would prevent it but it still happens
Do you know if there is a way to wait the first submission is finished before another one can be launched (in case not success it should be possible for user to change figures and resubmit the page)?
Hope I was clear enough and You will get all needed informations
Thanks
Best regards,