tag:blogger.com,1999:blog-6335343228190511009.post5304347177826774838..comments2023-10-17T03:07:46.787-07:00Comments on Oracle Apps Technology: SQL to create user with System Administrator privilegesVikram Dashttp://www.blogger.com/profile/08777547738218549011noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6335343228190511009.post-90673570274498658362012-09-25T07:13:10.035-07:002012-09-25T07:13:10.035-07:00Enter value for enter_user_name: TEST111
old 5: ...Enter value for enter_user_name: TEST111<br />old 5: v_user_name VARCHAR2(30) := upper('&Enter_User_Name');<br />new 5: v_user_name VARCHAR2(30) := upper('TEST111');<br />DECLARE<br />*<br />ERROR at line 1:<br />ORA-20001: APP-FND-02912: User TEST111: The Person is linked to an invalid<br />Employee (Employee ID = 30).<br />ORA-06512: at "APPS.APP_EXCEPTION", line 72<br />ORA-06512: at "APPS.FND_USER_PKG", line 2960<br />ORA-06512: at "APPS.FND_USER_PKG", line 313<br />ORA-06512: at "APPS.FND_USER_PKG", line 3835<br />ORA-06512: at "APPS.FND_USER_PKG", line 1101<br />ORA-06512: at "APPS.FND_USER_PKG", line 1196<br />ORA-06512: at "APPS.FND_USER_PKG", line 1315<br />ORA-06512: at line 9Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-21978944508238144322009-01-14T12:41:00.000-08:002009-01-14T12:41:00.000-08:00Hi Ram,As per the error TEST123 already exists. I...Hi Ram,<BR/><BR/>As per the error TEST123 already exists. I tried your command in my test instance and it executed successfully:<BR/><BR/>SQL> BEGIN<BR/>APPS.FND_USER_PKG.CreateUser<BR/>(<BR/>'TEST123',<BR/>'CUST',<BR/>'TEST123',<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>SYSDATE+1,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL,<BR/>NULL<BR/>);<BR/>END; 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22<BR/> 23 /<BR/><BR/>PL/SQL procedure successfully completed.<BR/><BR/>- VikramVikram Dashttps://www.blogger.com/profile/08777547738218549011noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-17009965236041778062009-01-08T08:55:00.000-08:002009-01-08T08:55:00.000-08:00Hi! Vikram, Thanks for your reponse. We are passin...Hi! Vikram,<BR/> Thanks for your reponse.<BR/> We are passing employee_id, but still we are getting this error. Please let me know<BR/><BR/>Thanks,<BR/>RamuAnonymoushttps://www.blogger.com/profile/00812681153642721143noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-37246043288283962842009-01-07T19:33:00.000-08:002009-01-07T19:33:00.000-08:00Hi Ramu,You need to run the sql exactly as it is g...Hi Ramu,<BR/><BR/>You need to run the sql exactly as it is given in the post. x_employee_id needs to be given. It doesn't work if x_employee_id is null.<BR/><BR/>- VikramVikram Dashttps://www.blogger.com/profile/08777547738218549011noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-34743032135071141232009-01-07T08:15:00.000-08:002009-01-07T08:15:00.000-08:00Hi! Vikram, As Chris told, we are getting the same...Hi! Vikram,<BR/> As Chris told, we are getting the same error "ORA-20001: Custom user name validation in subscription to event oracle.fnd.user.name.validate failed". This error is not getting on one landscape where we connected to Database other than APPS users and gave neccessary grants and created synonyms. But in another landscape we are getting this error (same grants and synonyms are created for User). <BR/><BR/>Please let know what might be the problem.<BR/><BR/>Thanks,<BR/>RamuAnonymoushttps://www.blogger.com/profile/00812681153642721143noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-64004705355394992212008-10-24T02:35:00.000-07:002008-10-24T02:35:00.000-07:00Hi I use following command and try to add FND_USER...Hi <BR/><BR/>I use following command and try to add FND_USER<BR/><BR/>BEGIN <BR/>APPS.FND_USER_PKG.CreateUser <BR/>( <BR/>'TEST123', <BR/>'CUST', <BR/>'TEST123', <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>SYSDATE+1, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL, <BR/>NULL <BR/>); <BR/>END; <BR/><BR/>but, I got <BR/> Error: ORA-20001: Unabled to create user TEST123 for this following reason:<BR/>This user name is already in use. Please enter a unique user name..<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 367<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 410<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 529<BR/>ORA-06512: at line 2<BR/><BR/>Any comments?<BR/><BR/>Thanks<BR/><BR/>MichaleAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-3301772567765200692008-08-09T22:56:00.000-07:002008-08-09T22:56:00.000-07:00Hi Chris,Do you mean that you are connecting to th...Hi Chris,<BR/><BR/>Do you mean that you are connecting to the database as a non APPS user and running this script ? If yes, it won't succeed, you need to be connected to the database as the APPS user. <BR/><BR/>- VikramVikram Dashttps://www.blogger.com/profile/08777547738218549011noreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-31655600332893903652008-08-06T16:10:00.000-07:002008-08-06T16:10:00.000-07:00Question. When using an account other then APPS I...Question. When using an account other then APPS I get the following error:<BR/><BR/>ORA-20001: Custom user name validation in subscription to event oracle.fnd.user.name.validate failed.<BR/>ORA-06512: at "APPS.APP_EXCEPTION", line 72<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 3367<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 696<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 891<BR/>ORA-06512: at "APPS.FND_USER_PKG", line 1010<BR/>ORA-06512: at line 1<BR/><BR/><BR/>Any idea how to get around this?<BR/><BR/>Thanks,<BR/>ChrisAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6335343228190511009.post-26730845693436618772008-02-20T08:24:00.000-08:002008-02-20T08:24:00.000-08:00Thanks, This help me out great. - DeepakThanks,<BR/> This help me out great.<BR/> <BR/>- DeepakAnonymousnoreply@blogger.com