Login Issue with users

[prabhunoule]

We are applying interoperability patches using 2580629.1. After applying patches, users unable to login to application, it says login failed. When we change the password, it works. Is it serious issue or what might went wrong? Any idea? Please suggest. We have database upgrade to 19c tomorrow. Currently we are on 11.2.0.4 and application version is R12.1.3. PFA.



Best Regards,
Prabhu

[prabhunoule]

Please find output for below queries:

SQL>  select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;

 

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
Y



1) SQL> set serveroutput on
declare
v varchar2(1);
begin
v := apps.fnd_web_sec.validate_login('GORAKSHA.PRAMOD', 'sairam.123');
dbms_output.put_line('Valid? ' || v);
dbms_output.put_line('Message : ' || apps.fnd_message.get);
end;
SQL> 2 3 4 5 6 7 8
9 /
Valid? N
Message : PASSWORD_INVALID

PL/SQL procedure successfully completed.



2) SQL> set serveroutput on
declare
v varchar2(1);
begin
v := apps.fnd_web_sec.validate_login('SYSADMIN', 'sysadmin123');
dbms_output.put_line('Valid? ' || v);
dbms_output.put_line('Message : ' || apps.fnd_message.get);
end;
SQL> 2 3 4 5 6 7 8
9 /
Valid? Y
Message :

PL/SQL procedure successfully completed.

[ErmanArslansOracleBlog]

When did the issue start? After which patch exactly? There are lots of EBS patches which need to be applied.. But, we don't expect such an issue with the Application user passwords. Do you have SSO or OAM enabled?
Did you read all the readme files of those patches? Are there anything related with the passwords? Anything , any action that you missed there?

[prabhunoule]

Hi Erman,
This issue is solved by changing passwords and upgrade is successful.
Thanks for the support.