The social network for Oracle people

username password not working from query but working from browser

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

Tags: E-business, Oracle, and, htms, labor, login, oracle, otl, suite, time

Replies are closed for this discussion.

Replies to This Discussion

Permalink Reply by Eddie Awad on November 1, 2012 at 11:48am

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.

Permalink Reply by Ram Sharan Mittal on November 4, 2012 at 10:56pm