Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle APEX Form Region Not Saving Data

rgiljohannJan 4 2023

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: rgiljohann@simitreehc.com=
PS: simitest

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

This post has been answered by InoL on Jan 5 2023
Jump to Answer

Comments

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.

image.png

InoL
Answer

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.

Marked as Answer by rgiljohann · Jan 5 2023
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!

1 - 5

Post Details

Added on Jan 4 2023
5 comments
1,458 views