SAP Note 26762 - Selection from a view returns invalid result set

Symptom:

After changing the selection criteria of a database view, the results of quotation requests do not change appropriately.

Cause and prerequisites

This involves an unknown problem in the R/3 environment in conjunction with the database Informix OnLine.
Every database statement from R/3 is passed to the Informix database via dynamic SQL. Information about these statements is stored locally for performance reasons for a certain time in the respective work process. If the view is now deleted in the database and recreated with the same external structure (that is, only the view selection was changed), further execution of the stored Informix database statement is handled correctly (that is, without an error message) -- unfortunately, however, the number of hits does not change as it of course should.

Solution
A currently required displacement of this statement from the work process storage is not explicitly controllable -- it occurs implicitly according to certain criteria. The only short-term solution at this point is to restart the system; or at least the work process in which the information was stored. Since this can often only be determined with difficulty, there is, as already stated, often only the option to restart the entire system. The problem was reported to Informix and will be corrected in a subsequent version that has not yet been named. From the viewpoint of SAP, there is currently no praktical program strategy to get round this problem.
For this reason, you should change the view definitions as rarely as possible and, if in doubt, restart the system after this. A corresponding development request was created, however we cannot currently make any statement about the general availability of a solution.

Additional key words

PTS PTS_BUG PTS_BUG_43132