APEX 24.1.5
I have learnt the hard way about impatient users pressing button multiple times on submit and have ended up with duplicate records. This is just standard APEX form. We also have wizard that uploads and processes file data, again if button pressed multiple times, file is processed multiple times.
I was not familiar with the Enable Duplicate Page Submissions page level setting until researched issue. Duplicate record when create (insert) data - Oracle Forums is simple case of others having same issue.
Once set Enable Duplicate Page Submissions to No - Prevent pages from being re-posted, no duplicate records when impatient users press button multiple times.
What is the use case where this would be set to Yes - Enable page to be re-posted?
I wonder why the default is Yes - Enable page to be re-posted?
Just wish to understand this fundamental concept as does affect every page that has submit button that would cause problems if submitted multiple times.