We're experiencing similar problems. Running 4.01 on 11.2 and starting to see ORA-14450 error on multiple pages. The exact error is as follows:
to access a transactional temp table already in use
Not sure how long this has been happening. A user actually received the following msg and is the only reason we know:
Rendering of page item P300_ANNUAL_ACTIVE_INACTIVE raised the
The page item in the error message is a static2 select list. We also receive this error on several other pages which contain combinations of text fields, radio buttons and text areas.
We are not using any global temporary tables in the app. Any advice, etc. greatly appreciated.