Please help me on this one, I know not where the error is coming from. I'm trying to update a record in a form that edits an equipment inventory, I could not paste the image so is kinda as follows:
I can edit any field but the TAG (which is the primary key). The error shown is:
ORA-01403: no data found
any advise will be good, I just can hit the issue.
Thanks in advance.
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.
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.