- WHO columns are used to track the information inserted or updated by the users against the tables. FND_STANDARD package is used for this purpose. FND_STANDARD.SET_WHO Procedure is used in BEFORE-INSERT or BEFORE-UPDATE triggers at block level in Oracle Forms to update the WHO columns in a Table when a DML operation s (i.e. INSERT, UPDATE) performed.
- Created_by
- Creation_date
- Last _updated_by
- Last_update_date
- Last_update_login
- Use fnd_profile.VALUE ('USER_ID') profile value for retrieving the user_id which will be used by created_by column.
- Creation date and last_update_date will be normally SYSDATE.
- Last_updated_by is same as created_by.
- Use USERENV ('SESSIONID') for getting the last_update_login id.
No comments:
Post a Comment