The social network for Oracle people
In Oracle Time and Labor, we are using employee number and password(employee no: 201456 password: 201456_password). If I go to e business suite in web browser it works fine but if I try select fnd_web_sec.validate_login('201456 , '201456_password') from dual it is returning N.
Please guide me
thanks in advance
Replies are closed for this discussion.
The function fnd_web_sec.validate_login accepts a username and a password. It looks like you're passing the employee ID as the username. You should pass a user name that exist in fnd_user.
Instead of using fnd_web_sec.validate_login, which is for internal Oracle use only, I suggest you use the public API fnd_user_pkg.validatelogin instead.
-- Eddie Awad.
thanks, help me a lot.