Technology Stack - EBS (MOSC)

MOSC Banner

Call FND_USER_PKG.CreateUser from another Oracle Schema (not APPS)

edited Aug 20, 2021 11:28AM in Technology Stack - EBS (MOSC) 3 commentsAnswered ✓
Hi,
I have the request to give enough privilege to an oracle schema (not APPS) so that this schema is able to create new EBS users.
I granted on execute the FND_USER_PKG package to this schema and try to call the procedure APPS.FND_USER_PKG.CreateUser.
I have encapsulate the call in a procedure like this:

  PROCEDURE createUser(username IN VARCHAR2,description IN VARCHAR2, fax IN VARCHAR2) IS
  BEGIN
    APPS.FND_USER_PKG.CreateUser(username,'SEED',null,0,sysdate,null,null,description,null,null,null,null,null,null,fax,null,null);
  END;

I get the following error.

ERROR at line 1:

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