neomukesh

 Profile Answers by neomukesh 

• Jun 26th, 2010

 

WHO columns are maintained to know who updates the particular rows ans when.

last_update_date, last_updated_by, creation_date, created_by, last_update_login are 5 WHO columns. following information should be updated in these columns:

 

1. Last_update_date: sysdate when a change is made to already existing records

 

2. Last_updated_by: fnd_global.user_id can be stored in a variable and update this field with variable

 

3. Creation_date: sysdate when the record is created

 

4. Created_by: fnd_global.user_id can be stored in a variable and update this field with variable when record is created

 

5. Last_update_login: FND_LOGINS.LOGIN_ID can be stored in a variable and update this field with variable when record is updated