Monday, August 25, 2008

How to restrict Who columns from being updated in HRMS

The "last_update_date" and "last_updated_by" fields are for audit purpose and are automatically used by the APIs.

set the parameter hr_general.g_data_migrator_mode = Y to disable entering who columns before your script.

Note: Although you can disable the ROW WHO columns from being updated as indicated, this will potentially cause an auditing nightmare if the batch update system updates incorrect data or fields. In such a case, the last person who updated the row thru the application pages or forms (i.e in a valid manner) might be accused of trickery :).

Please make sure that you test it in your test instance before moving to PROD.

2 comments:

SAURABH said...

What about FND tables like fnd_user ? How to suppress WHO column updates here ?

Arun Kumar S.R said...

Saurabh.. As far as I know we don't have any setups or standard triggers that can be disabled for FND_USER table.