User Account Package
This package creates user accounts for companies based on some criteria in HR that the user defines.
The process runs a batch job (e.g. every night) which:
a) creates new users
b) allocates responsibilities
c) end dates responsibilities, and
d) end dates user accounts.
Platform: Sun Solaris: SPARC, x86, x86-64
Database Version: Oracle 11g (Release 1): 11.1.0.6 - 11.1.0.7
Development Tool: PL/SQL
Product: Human Resources, Oracle E-Business Suite
Technical Overview: The program calls a PL/SQL Package which contains the logic to perform updates using the delivered API's.
The code has five major components:
1) Creating new user accounts.
2) Allocating responsibilities to these accounts.
-- Both of the above are managed using an HR Assignment Set, which allows the end user to dictate which criteria to use (for example, allocate the "Shares" responsibility to all people who have the Element "Shares" - totally user defined and all the code does is take the parameter of which Assignment Set to use.
3) Allocating Manager responsibilities (again, using a parameter)
4) End Dating Responsibilities
5) End Dating Accounts.
The user runs the Program from a Concurrent Program.
Business Overview: Tired of allocating access to users manually? Audit getting on your case for not ending access when people leave / move jobs?
This program, run from within Oracle, uses HR Assignment Sets (user defined groupings of people) to manage user access.
It also sends an email to new users, telling them that an account has been created and generates their first password for them.
Known Bugs / Limitations: The code expects an HR Assignment Set to be used, so you should have at least HR installed.
However, you could take this code and comment out that section, which means that you could use any other criteria you wanted. (For example, if you are using CRM you could adapt this for the CRM footprint.)
Initial business requirements specification bundled: Yes
Install guide bundled: Yes
User guide bundled: Yes
Test scripts bundled: Yes
Consulting bundled: Yes
Skills Needed to Implement: DBA and Functional d
Expected Time it should take to Implement: 4 hour
Pricing: £2,000.00
There are no ratings for this package yet.