Technology Stack - EBS (MOSC)

MOSC Banner

What to run fnd_web_sec.change_password as a user other than apps

edited Jan 25, 2018 1:39PM in Technology Stack - EBS (MOSC) 4 commentsAnswered
We have requirenment to use fnd_web_sec.change_password as an API to change R12 front end password. So we want to run it from an account other than APPS. The procedure uses AUTH CURRENT USER and references various tables and functions etc. I have granted access to all these to the new user I wish to run fnd_web_sec.change_password. And yet still it does not work.

Logged on as new user HITACHI we get:

SQL> DECLARE stat VARCHAR2(30);
BEGIN stat := fnd_web_sec.change_password('AJARLSON','Welcome12') ;
IF stat <> 'Y' THEN RAISE_APPLICATION_ERROR(-20001,'Fail - ' || fnd_message.get);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center