Thursday, 23 March 2017

Who Columns in Oracle Apps

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