| User Management (UMX) Stored Procedures? [message #160635] |
Mon, 27 February 2006 18:20 |
aculrich
Messages: 8
Registered: February 2006
|
Junior Member |
|
|
I am new to PL/SQL stored procedures and Oracle and am trying to figure out which stored procs the UMX tool uses in the background.
I have to load about 1000 users into the database and assign roles to them. I tried using a test script using the UMX tool, however this will not work (due to the association that needs to be made to an organization) and I will need to execute stored procedures.
Can someone please guide me as to which stored procs I should use?
The stored procedures I think I need to use are:
HZ_PARTIES_PKG.InsertRow
FND_USERS_PKG.CreateUser
FND_USERS.PKG.addResp
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
