Home » Applications » Oracle Fusion Apps & E-Business Suite » App Users
App Users [message #139372] Tue, 27 September 2005 13:47 Go to next message
PattyAtT
Messages: 3
Registered: September 2005
Location: USA
Junior Member
Is setting the end_date of a user sufficient, or is there a way to drop/remove the user entirely from the application...

We're going through Sarb-Ox compliance right now, and I got the following question from our auditors:
"
Why are they being maintained if they have been in-active for 4 years?
"

Report message to a moderator

Re: App Users [message #139382 is a reply to message #139372] Tue, 27 September 2005 15:08 Go to previous messageGo to next message
mchittib
Messages: 87
Registered: September 2005
Member
You can only give an end date. You cannot delete a user, probably they are stored, if at a later stage the user comes back to company, or to track the events done by that user.

Report message to a moderator

Re: App Users [message #139415 is a reply to message #139372] Tue, 27 September 2005 22:53 Go to previous messageGo to next message
manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC
Senior Member
Whenever you upgrade system, you can trim them. Otherwise most of the companies put users in system with disabled status. It is not worth efforts to delete them from system because you have to delete transactional data also it, which can be important and very big. I think as per SEC, companies have to maintain data for at least for 7 years.

Report message to a moderator

Re: App Users [message #140064 is a reply to message #139415] Fri, 30 September 2005 12:51 Go to previous messageGo to next message
AnalystParth
Messages: 15
Registered: September 2005
Location: India
Junior Member
Well if the idea is to convince/explain to the auditors, there are plenty of reasons, a few below should help:

1. Lets say user X made a transaction for a million that has got recorded in the GL, and it happens 4 years ago. Are we better off keeping his information or loosing it?

2. As suggested by manwadkar, why loose the primary record that links a host of other user related transaction history

3. This information is not like paper based documents which one would feel is loading up space or adding to complications. So why not just leave it around, just in case you want to check some old archived history sometime later?

4. Its just two tables that maintain the user information (mainly) fnd_users and hz_parties. So why really bother about cleaning it up?

Now getting to the key concern that auditors probably have, "If a user is to be closed then the "clean" way would be to remove his record rather than just disable him. There is always be the danger of getting him revoked"
Well end dating as far as the application goes is the best way to disable him. Applications doesnt prefer deleting for reasons cited above. And you are better off diabling and enabling users as per requirement than deleting, loosing all his data and adding him back as if he were a new user!

--Parth

Report message to a moderator

Re: App Users [message #141060 is a reply to message #139372] Thu, 06 October 2005 14:59 Go to previous message
wtolentino
Messages: 398
Registered: March 2005
Senior Member

In technical perspective it is to maintain data integrity.

Report message to a moderator

Previous Topic: can anyone explain Customer interface in detail
Next Topic: Where can I find date in database on which Oracle Apps is installed?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 09 19:54:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.