The initial idea was to create new accounts and end-date the old accounts in Oracle eBS. However, it turns out that you can rename them by making use of the change_user_name function which can be found in the fnd_user_pkg package in the database.
The example Amar is using on his weblog is the example below:
begin fnd_user_pkg.change_user_name( x_old_user_name => 'AMARKP', x_new_user_name => 'AMAR.PADHI' ); commit; end; /Without much effort you could create a script to mass update all the users that are in need of an update. You do most likely would like to add some reporting, logging and notification to this script to make it robust however the use of fnd_user_pkg.change_user_name will play a central role.
2 comments:
It would generate lot of workflow events, your workflow system should be good enough to process these events in time....
True... however you can work around the workflow issue if you code smartly and your workflow engine should be able to cope with a high load anyway... so if your workflow mailer engine for example brakes it was already incorrect implemented (in my opinion).
Post a Comment