Experts,
For several months now, we migrated from Oracle AS SSO to Oracle Access Manager (OAM) in our development environment.
Since the upgrade, a "ora-1403: no data found" error occurs sometimes. You've all seen this page before: white page, red cross with text in black and that's about it.
The error shows up randomly, sometimes once a day, sometimes not for several days and then a few times a day, both in the runtime as in the application builder.
There are multiple developers using this environment but only one of them is having the error so it's not a general failure of the framework.
Neither is it a blocking error 'cause you can use the back button and submit again without losing any data or changes.
Our test - and production environment are still on Oracle AS SSO and we don't get the error there so I guess it's not an APEX related error but I need to be sure on this.
Our DBA already set-up PL/SQL debugging in Apache but the error doesn't show up here.
We do see a "ora-6550: wrong number or types of arguments in call to wwv_flow.show" but it's unclear whether both errors are related or not.
Is anyone having tips, ideas, best practices,... to gather more information about the error?
Is there some logging table in the APEX database scheme where I can look for error logs? Or a log file somewhere?
We want to isolate the error and figure out why we are getting this but it's hard without debug information.
This error is keeping us from moving to OAM in production so it's getting important.
I hope someone can help us out!
The release numbers:
Database: 11.2.0.3
APEX: 4.2.3 but this error already occured in 4.2.1 and 4.2.0
Oracle Access Manager: 11.1.2.1
Kind regards and thanks in advance for any help,
Bart Peeters