WHO Columns (with eg) that are commonly used in Oracle apps are:
- Created_by - User Id.
- Created_date - SYSDATE.
- Last_update_date - SYSDATE.
- Last_updated_by - User ID.
- Last_update_login - Login ID.
- Request_id - Conc request id.
We derive values for who columns by below seeded functions.
Created_by := fnd_profile.value('USER_ID')
Creation_Date := SYSDATE
last_update_Date := SYSDATE
last_updated_by := fnd_profile.value('USER_ID')
last_update_login := fnd_global
request_id := fnd_global.conc_request_id
No comments:
Post a Comment