Hi everyone,
I’m having an issue with my Oracle APEX form. Here's what happens:
- When I create a new record, everything works fine and the data is saved correctly in the database.
- However, when I go to edit the existing data, I see the value I set using Set Value, but it disappears almost immediately and becomes null.
- I confirmed that the data does exist in the database, and it should be loaded when editing.
- I’ve already disabled “Fire on Initialization”, but it didn’t make any difference.
It seems like the Set Value process runs for a moment, sets the value, then something clears it. I'm not sure what causes the field to reset to null after showing the value briefly.
Ideally, once the data is created, it should appear correctly during edit mode—even if I don’t manually set the value again.
Any ideas what might be causing this? Could it be a process order issue or something else?
Thanks in advance!