APEX

Hi,

I've been searching through the forum and the Internet with no results, so I'm posting here hoping you can help me.

Here is the situation: I had a page 30 with a tree branching to a form on a view.This worked fine until one day that suddenly, we got the "ORA-01403: no data found" error when loading the page. I guess that's normal, since the form shows the data filtered in the tree (in the tree we click on an element and pass its ROWID to the form), and when we load the page no ROWID is selected. So, the first question would be, how can I manage this situation? My first option was to have a condition in the Automatic Fetch for the Form, so that it's executed only when the ROWID item is not null. It worked a couple of times. After a while, it crashed again.

Tired of trying things, we decided to copy this page 30 to another page (page #80). Surprisingly, page #80 worked meanwhile #30 crashed. And they are completely the same, the data has not changed either.

Could it be that page #30 somehow is corrupted? It's really strange that the same exact copy of the page works with one ID but not with another one.

Has someone experienced this situation? it makes me feel like the app is unsecure and unstable. Any ideas, please?

Apex version: 4.1.1 on APEX listener.

Thanks,
Elena.