From the error, I would go to process 'Fetch Row from EQUIPMENT'. This process is resulting such that when the SELECT query runs, there is no data returned.
1. If it is an Automated row fetch then check if you are setting the value for the item that has the value of primary key.
2. If it is a process you wrote yourself then you might want to check the where clause in it (and the item if you are using one in the where clause).
When are you getting this error? on Page Load or On page Submit?
In any case, it's good idea to check page process which loads data into form. Please check if the process is conditional so it only executes when Primary Key value is NOT NULL. Also make sure that users can't pass Primary Key value to the Page, it should be automatically set by clicking on a link for e.g.
Hello, thanks for your reply.
It is Automated Row Fetch and it is setting the value for the Item with primary key; I just checked.
....Still looking for the reason of failure, if you have something in mind thanks for charing
The debug info says it is in the Automated Row Fetch process, the said is in the "On-Load After Header" process point. It happens when I click the apply changes button which submits the page.
There are no conditions - I tested applying condition but same behavior.
It happens even if i create the pages again...
I can update through SQL with SQL Developer, so Table should be ok.
it just happens when updating.
The reason I see here is that the Primary key item is empty during "On-Load After Header", i.e when the page loads again. After Apply Changes, check if you are setting the value of that item in the Branch section. It might be that the Item is becoming null when the page loads again and the value is not set until the Fetch Row process occurs.
To check this, you could add a condition to Fetch row such that it runs only when the Primary key item is not null. Use Debug feature of APEX and see if the Fetch runs.
Hi again, I just want to add that the issue seems to be in any form and the the problem is on the item that relates to the primary key, if i change the value to a totally different thing it wont work (ORA-01403), if i change it to the same original value it would work.