I was upgrading my Forms 11g application to 12c.
Installed FMW and configured weblogic domain.
Compiled all my 11g forms in 12c builder including fmb, mmb and pll , though there are some issues i had all FMX, MMX and PLX files created.
Configured fmwweb.cfg, default.env files, TNS_ADMIN under $ORACLE_HOME\user_projects\domains\myappdomain\config\fmwconfig , started the weblogic server, application is launching in Edge browser under IE mode.
we use Oracle database Accounts for login (Oracle 19c). when providing the userName and password application throws exception alert message
did some debugging on ON-LOGON trigger and the control goes to the following procedure but fails with the above error. There are no hits to the database with these parameters. I could connect to the account from SQLPLUS using same credentials.
LOGON(
LOWER(:logon_parms.emp_id_flag||:LOGON_PARMS.TNS_USERNAME)
,LOWER(:LOGON_PARMS.TNS_PASSWORD)||'@'||LOWER(:LOGON_PARMS.TNS_SERVICE)
,FALSE
);
I see all the parameter values are populated correctly before calling LOGON function.
I am new to Forms and Report but not to programming. any help is highly appreciated.
Thank you