In our TRN environment, I have created a couple of test records. I created a System, Position, and an Asset. I was able to link the Position to the System, but when I tried to link the Asset to the Position, I received the following error "no data found". I've been creating systems, positions, and assets for years, so I'm not doing anything any differently, so I'm at a loss as to why I'm receiving this error.
The "no data found" error occurs due to an issue with one or more of the flex business rules. The flex statement is attempting to pull a query, and the query is not pulling any data. This then throws the "no data found" error.
If it is throwing this error, and you think the flex should be pulling data, then you want to go back and check over your queries. If you know that it should not be pulling data, and you do not want to see this error in those cases, you can add an exception to the flex. This looks like:
EXCEPTION
WHEN no_data_found THEN
NULL;
This means that whenever no data is found by the select statement, the flex rule will simply end instead of throwing the error.