Scenario:
Access Forms Applcation Page using user1/password@devdb successful. Then Login Page using credential that store in table example: userid = appuser1
password = oracle1234!
With those credential success login to the application and try to call reports from the page
Output as below:
Open the trace log:
rwservlet-diagnostic.log
rwEng0-diagnostic.log
the tnsnames.ora is pointing correctly.
$DOMAIN_HOME/config/fmwconfig/tnsnames.ora
The forms able to connect and login using user and password that store in table but when try to call reports its failed to connect database.
This doesn't happen in old environment which forms 12c and database 12c.
After upgrade to database 19c, this was happened.
Any recommended solution?
Thanks.