This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions
  • 7,916,821 Comments

Discussions

Oracle APEX Form Region Not Saving Data

rgiljohann
rgiljohann Member Posts: 13 Green Ribbon

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.

Tagged:

Best Answer

  • InoL
    InoL Member Posts: 10,361 Blue Diamond
    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.

Answers

  • InoL
    InoL Member Posts: 10,361 Blue Diamond

    I have a form region in my application

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

  • rgiljohann
    rgiljohann Member Posts: 13 Green Ribbon

    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
    InoL Member Posts: 10,361 Blue Diamond
    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.

  • rgiljohann
    rgiljohann Member Posts: 13 Green Ribbon

    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
    InoL Member Posts: 10,361 Blue Diamond

    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!