Call FND_USER_PKG.CreateUser from another Oracle Schema (not APPS)
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:
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:
Tagged:
0