Hi there, I am using:
- Oracle 11g Database
- Oracle Reports 6i
- Oracle Forms 6i
I'm experiencing an issue when calling a report from an oracle form.
After log in and run a form, I trigger a run_product() function calling a report, it will request the user to connect before running the report, like if the user session is lost or it is not detecting the current session that was initiated in forms.
However this is not happening every time, but still being like 1 of each 5 times.
I'll appreciate a lot your help.
Our application (forms and reports 6i patch 18) runs against database 11gR1 just fine.
What we do:
Change "sec_case_sensitive_login" = FALSE
Make sure you change it within the SPFILE as well as on the running DB, so when the DB starts, the parameter get picked up too.
We change db_recovery_size, open_cursors, processes as well, but the "sec_case_sensitive_login" is what should do the trick.
Our application runs sometimes run_report_object, sometimes run_product, depending on which module is more up to date, so that doesn't matter.