Friday, November 07, 2014

PLSQL API to validate  Oracle E-business Suite Login Credentials.



1. Call the below API to validate user/password details of  Oracle E-Business Suite
FND_WEB_SEC.VALIDATE_LOGIN( '<userName>','<password>')

Ex : select FND_WEB_SEC.VALIDATE_LOGIN( 'OPERATIONS','welcome') from dual ;

Returns 'Y' -- if valid , else returns 'N'

No comments: