Oracle APEX Form Region Not Saving Data

rgiljohann

Hello,

I have a form region in my application. I am not sure what happened, but it does not save data. I got it to work before, but for some reason it is not anymore. I am on Apex 21.2.

It is using a Automatic Row Processing process.

I uploaded it to Apex.oracle.com if anyone wants to take a look.

Workspace: simitreetest

user: [email protected]=

PS: simitest

I get a record was saved message after trying to save, but nothing is saved in the end. Thanks.

InoL

If you run your page in debug mode you see weird things happening. Always run in debug mode if you don't know what is happening!

As far as I could see you had both a Submit default action and a Click DA on your Save button. I removed the DA, and now it works.

InoL

I have a form region in my application

There is a whole application in your workspace. Where is the problem?

rgiljohann

The form is on page 3 called Audit. You can get there by clicking on the links on the report page to populate existing records which is how the end users will end up doing it.

InoL

If you run your page in debug mode you see weird things happening. Always run in debug mode if you don't know what is happening!

As far as I could see you had both a Submit default action and a Click DA on your Save button. I removed the DA, and now it works.

rgiljohann

You are awesome. Thank you. It is odd that having a DA causes it to fail, but I can worry about that some other time. Thanks again.

InoL

It is odd that having a DA causes it to fail

Not at all. Your button has the Submit action, and your DA had it too too. That caused a double submit, as you can see in the debug log if you put that DA back. That totally f*ed up the whole process. Debugging is the most important tool a developer can have!