Issue: Running an Oracle Report Requires Login Every Time After PITSS.CON Upgrade
The cause of the problem:
The issue was that PITSS.CON added the following code:
rp2rro.rp2rro_Add_parameter(PL_ID,’USERID’, TEXT_PARAMETER,get_application_property(username) /get_application_property(password) || db_connect_string);
The customer did not know why this was added, so they removed this. After the code was added, when the developer boxes tried to run reports, they were prompted for a login every time. The above is required so that a cookie can be passed in between reports and IE which lets the report be run without re-authenticating the user.
NOTE: The issue relates to an older version of the PITSS-supplied tmrp2rro.pll library. This library is a slightly modified version of the rp2rro.pll library which comes with every Oracle Forms and Reports installation. Newer versions of tmrp2rro.pll (for 10g, 11g, and 12c) should not have this issue. If you run into this problem when upgrading a form with PITSS.CON, please contact PITSS Support for a new PL/SQL library.
